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

(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.

MemberUniqueId

(Required)

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

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

Usage Scenarios

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

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