Returns the member of a specified position of an MDX statement.
Syntax
XL3MdxMemberLookup( Connection, MdxExpression, [Axis], [Hierarchy], [Position], [Format] )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| MdxExpression | The MDX expression to run. |
| Axis | The number of the axis to obtain the member from. 1-based, and defaults to the first axis if omitted. |
| Hierarchy | The number of the hierarchy on the axis to obtain the member from. 1-based, and defaults to the first hierarchy if omitted. |
| Position | The number of the member on the hierarchy to use. 1-based, and defaults to the first member if omitted. |
| Format | The format to use for the returned member. 0 - Member caption (default) 2 - Member unique name |
Example
This example is based on the Bicycle Sales cube.
Returns the second child of the product group 'Mountain'.
=XL3MdxMemberLookup( 1, "Select {[Product].&[Mountain].Children} on Columns from BicycleSales", 1, 1, 2 )
