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.