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

(Required)

Specify the Analysis Services server that you want to connect to.

Catalog

(Required)

Specify the catalog of cubes on the datasource that you want to perform your query on.

Cube

(Required)

Specify the cube that you want to perform your query on.

Hierarchy

Specify the hierarchy name, if applicable.

Index

(Required)

Specify the ordinal (index) position which you want to retrieve information about.

Return Property

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

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.

Input of value of Datasource, Catalog, Cube, and Index are compulsory, while other arguments are optional.