Members

Return to: Calculated Member Builder Function List

Returns the set of members in a dimension, level, or hierarchy, or the member whose name is specified by a string.

Syntax 1

«Dimension».Members

Remarks 1

Returns the set of all members in «Dimension».

Example 1

Geography.Members

returns the set of all members in the Geography dimension.

Syntax 2

«Hierarchy».Members

Remarks 2

Returns the set of all members in «Hierarchy».

Example 2

Time.Quarterly.Members

returns the set of all members in the Quarters hierarchy of the Time dimension.

Syntax 3

«Level».Members

Remarks 3

Returns the set of all members at a specified level in a dimension.

Example 3

If the Year level contains [1994], [1995], and [1996], then:

Year.Members

returns the set

{[1994], [1995], [1996]}.

Syntax 4

Members(«String Expression»)

Remarks 4

Returns the member whose name is given by «String Expression». Typically used with user-defined functions.

Example 4

Members(UDF())

where UDF() is a user-defined function that returns a string.