Skip to content

CMEMBERCHILD

The CMEMBERCHILD formula is an enhanced member function that provides the ability to return members that are the children of a given member within a hierarchy.

Syntax

CMEMBERCHILD (Datasource, Catalog, Cube, MemberUniqueId, Index, ReturnProperty)

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.

MemberUniqueId : string (required)

Specify the Unique Id of the member which you want to retrieve information about.

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

Usage Scenarios

To return members that are the children of a given member within a hierarchy.

All arguments except Return Property are required.