| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3MdxMemberLookup"
(Created page with 'Returns the member of a specified position of an MDX statement. ==Syntax== {{Code|XL3MdxMemberLookup( Connection, MdxExpression, [Axis], [Hierarchy], [Position], [Format] )}} …') |
(Added categories) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 27: | Line 27: | ||
| {{Code|Format}} | | {{Code|Format}} | ||
| The format to use for the returned member. | | The format to use for the returned member. | ||
| − | + | {| class="wikitable" | |
| − | + | | 0 || Member caption (default) | |
| + | |- | ||
| + | | 3 || Member unique name | ||
| + | |} | ||
|} | |} | ||
| Line 39: | Line 42: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | * [[XL3MdxLookup|XL3MdxLookup formula]] | ||
| + | |||
| + | [[Category:Formulae]] | ||
| + | [[Category:OLAP Formulae]] | ||
Latest revision as of 10:37, 8 October 2010
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.
|
Examples (based on the Bicycle Sales cube)
Returns the 2nd child of the product group 'Mountain'
=XL3MdxMemberLookup( 1, "Select {[Product].&[Mountain].Children} on Columns from BicycleSales", 1, 1, 2 )
