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.