Members
Returns the set of members in a dimension, level, or hierarchy. Alternatively, returns a member specified by a string expression.
Syntax
Dimension
«Dimension».Members
This syntax returns the set of all members in «Dimension».
Hierarchy
«Hierarchy».Members
This syntax returns the set of all members in «Hierarchy».
Level
«Level».Members
This syntax returns the set of all members at a specified level in a dimension.
String
Members(«String Expression»)
This syntax returns the member whose name is given by «String Expression» in Multidimensional Expressions (MDX) format. It is typically used with user-defined functions.
Examples
Dimension
This example
Geography.Members
returns the set of all members in the Geography dimension.
Hierarchy
This example
Time.Quarterly.Members
returns the set of all members in the Quarters hierarchy of the Time dimension.
Level
If the Year level contains [1994], [1995], and [1996], this example returns the set {[1994], [1995], [1996]}:
Year.Members
String
The following example returns a member, where UDF() is a user-defined function that returns a string in MDX format, such as "[Measures].[Unit Sales]":
Members(UDF())