| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3MdxLookup"
(Added reference to XL3MdxMemberLookup) |
(Added categories) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
==Syntax== | ==Syntax== | ||
| − | {{Code|XL3MdxLookup( Connection, MdxExpression, Column, Row )}} | + | {{Code|XL3MdxLookup( Connection, MdxExpression, [Column], [Row] )}} |
==Parameters== | ==Parameters== | ||
| Line 17: | Line 17: | ||
|- | |- | ||
| {{Code|Column}} | | {{Code|Column}} | ||
| − | | The result column to obtain the value from. 1-based. | + | | The result column to obtain the value from. 1-based, and defaults to the first column if omitted. |
|- | |- | ||
| {{Code|Row}} | | {{Code|Row}} | ||
| − | | The result | + | | The result row to obtain the value from. 1-based, and defaults to the first row if omitted. |
|} | |} | ||
| Line 32: | Line 32: | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[XL3MdxMemberLookup|XL3MdxMemberLookup formula]] | * [[XL3MdxMemberLookup|XL3MdxMemberLookup formula]] | ||
| + | |||
| + | [[Category:Formulae]] | ||
| + | [[Category:OLAP Formulae]] | ||
Latest revision as of 10:37, 8 October 2010
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 (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 )
