AllMembers

Analysis Services

Analysis Services

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