AddCalculatedMembers

Return to: Calculated Member Builder Function List

Adds calculated members to a set.

Syntax

AddCalculatedMembers(«Set»)

Remarks

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

Example

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

Function Returns
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]}

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.