Returns the value of an MDX statement.
Syntax
XL3MdxLookup( Connection, MdxExpression, [Column], [Row] )
Parameters
| Parameter | Description |
| Connection | Connection number to use |
| MdxExpression | The MDX expression to run |
| Column | The result column to obtain the value from. 1-based, and defaults to the first column if omitted. |
| Row | The result row to obtain the value from. 1-based, and defaults to the first row if omitted. |
Examples
This example is based on the Bicycle Sales cube and returns the level ordinal of the product 'Mountain'.
=XL3MdxLookup( 1, "WITH MEMBER [Measures].LevelOrdinal AS 'Product.CurrentMember.LEVEL.ORDINAL' SELECT {[Measures].LevelOrdinal} ON COLUMNS, {[Product].&[Mountain]} ON ROWS FROM BicycleSales", 1, 1 )
