Returns a name or caption of a member at a given level.
Syntax
XL3MemberLevelLookup( Connection, Position, Hierarchy, Level )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| Position | Number of member to return. |
| Hierarchy | Name of the hierarchy that the member applies to, for example, "Measures" or "[Customer].[Customer Geography]". |
| Level | Level whose child should be returned. |
Examples
These examples are based on the Bicycle Sales cube.
Returns Asia, the 3rd member on level Continent.
=XL3MemberLevelLookup( 1, 3, "Region", "Continent" )
