Returns a name or caption of a child of a given member.
Syntax
XL3MemberChildLookup( Connection, Position, Hierarchy, Member )
Parameters
Parameter | Description |
Connection | Connection number to use. |
Position | Number of child to return. |
Hierarchy | Name of the hierarchy that the member applies to such as Measures or [Customer].[Customer Geography]. |
Member | Member whose child should be returned. |
Example
This example is based on the Bicycle Sales cube.
Returns 'W7000/205', the 2nd child of 'Scenario W7000'
=XL3MemberChildLookup( 1, 2, "Product", "[Product].[Scenario W7000]" )