AddCalculatedMembers

AddCalculatedMembers

Returns a set generated by adding calculated members to a specified set.

Syntax

AddCalculatedMembers(«Set»)

Remarks

This function includes only the calculated members that are siblings in the set.

Example

In the preceding diagram, the following functions return the following values.

AddCalculatedMembers({GrandParent.Children})

{[Parent 1],[Parent 2],[Calculated member 0]}

AddCalculatedMembers({[Parent 1].Children})

{[Member 1.1], [Member 1.2], [Member 1.3], [Calculated member 1.4]}

AddCalculatedMembers({[Parent 2].[Member 2.1]})

{[Member 2.1], [Calculated member 2.4]}