| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3MdxLookup
Revision as of 18:06, 6 October 2010 by Antonio.remedios (talk | contribs) (Created page with 'Returns the value of an MDX statement. ==Syntax== {{Code|XL3MdxLookup( Connection, MdxExpression, Column, Row )}} ==Parameters== {| class="wikitable" ! Parameter ! Description…')
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. |
| Row | The result column to obtain the value from. 1-based. |
Examples (based on the Bicycle Sales cube)
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 )
