| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3SetLookup
Revision as of 14:48, 29 April 2016 by Antonio.remedios (talk) (Created page with "Returns a name or caption for a member in a given set. ==Syntax== {{Code|XL3SetLookup( Connection, SetExpression, [Position], [Format] )}} ==Parameters== {| class="wikitabl...")
Returns a name or caption for a member in a given set.
Syntax
XL3SetLookup( Connection, SetExpression, [Position], [Format] )
Parameters
| Parameter | Description | ||||
|---|---|---|---|---|---|
| Connection | Connection number to use | ||||
| SetExpression | The MDX expression to run | ||||
| Position | The number of the member in the set to return. 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)
The first region in Asia
=XL3SetLookup( 1, "[Region].&[Asia].Children" )
The unique name of the second child of Mountain
=XL3SetLookup(1, "[Product].&[Mountain].Children", 2, 3 )
