CMEMBERINDEX¶
The CMEMBERINDEX formula is used to retrieve a member of a hierarchy or subset according to their ordinal (index) position.
Syntax
CMEMBERINDEX (Datasource, Catalog, Cube, Hierarchy, Index, ReturnProperty, SubsetName)
Arguments¶
Datasource : string
(required)¶
Specify the Analysis Services server that you want to connect to.
Catalog : string
(required)¶
Specify the catalog of cubes on the datasource that you want to perform your query on.
Cube : string
(required)¶
Specify the cube that you want to perform your query on.
Hierarchy : string
(required)¶
Specify the hierarchy name, if applicable.
Index : number
(required)¶
Specify the ordinal (index) position which you want to retrieve information about.
Return Property : string
¶
Specify either the intrinsic member property (mdx) or the member attribute that you want to display in the cell. Member attributes should be in the form “[Dimension].[Hierarchy].[Attribute Name]”
Default value: MEMBER_CAPTION
Subset Name : string
¶
Specify the CALUMO subset that applies to this CMEMBER
Usage Scenarios¶
To retrieve a member of a hierarchy or subset according to their ordinal (index) position.
All arguments except Return Property
and Subset Name
are required.