Skip to content

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.