Export (0) Print
Expand All

AllMembers

SQL Server 2000

AllMembers

Returns a set containing all members of the specified dimension or level, including calculated members.

Syntax
Dimension

«Dimension».AllMembers

Level

«Level».AllMembers

Remarks

Semantically similar to the AddCalculatedMembers function, this function also includes only the calculated members that are siblings in the dimension or level. However, if there are no members, such as with the [Measures] dimension, the AllMembers function will still return the calculated members.

Example

In this diagram, the following example returns the set {[Parent 1],[Parent 2],[Calculated Member 0]}:

[GrandParent].AllMembers
Show:
© 2014 Microsoft