Returns a name or caption of a child of a given member.

XL3MemberChildLookup( Connection, Position, Hierarchy, Member )

ParameterDescription
ConnectionConnection number to use.
PositionNumber of child to return.
HierarchyName of the hierarchy that the member applies to such as Measures or [Customer].[Customer Geography].
MemberMember whose child should be returned.

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]" )