Difference between revisions of "XL3MemberFromLookup"
(Created page with "Returns a name or caption for a member. The member is retrieved from a cube call so can be calculated using MDX formulae. Normally cube values are retrieved using XL3Lookup...") |
(→Syntax) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | Returns a name or caption for a member. The member is retrieved from a cube | + | Returns a name or caption for a member. The member is retrieved from a cube cell so can be calculated using MDX formulae. |
Normally cube values are retrieved using [[XL3Lookup]], but these are put into batches and run together. This formula is useful if you want to look up a member name from a cube cell, and pass it on to XL3Lookup formulae. | Normally cube values are retrieved using [[XL3Lookup]], but these are put into batches and run together. This formula is useful if you want to look up a member name from a cube cell, and pass it on to XL3Lookup formulae. | ||
| Line 7: | Line 7: | ||
==Syntax== | ==Syntax== | ||
| − | {{Code| | + | {{Code|XL3MemberFromLookup( Connection, ResultHierarchy, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )}} |
==Parameters== | ==Parameters== | ||
| Line 21: | Line 21: | ||
{{Standard_HierarchyMember_List}} | {{Standard_HierarchyMember_List}} | ||
|} | |} | ||
| + | |||
| + | [[Image:XL3MemberFromLookup.png|350px|centre]] | ||
==See Also== | ==See Also== | ||
Latest revision as of 14:13, 25 March 2020
Returns a name or caption for a member. The member is retrieved from a cube cell so can be calculated using MDX formulae.
Normally cube values are retrieved using XL3Lookup, but these are put into batches and run together. This formula is useful if you want to look up a member name from a cube cell, and pass it on to XL3Lookup formulae.
If you want the result of a look-up to be a member you need the value to be returned before the other formulae are evaluated, and this function does that.
Syntax
XL3MemberFromLookup( Connection, ResultHierarchy, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| Parameter | Description |
|---|---|
| Connection | Connection number to use |
| ResultHierarchy | Name of the hierarchy that the resulting member applies to e.g. "Measures" or "[Customer].[Customer Geography]" |
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the following member applies to e.g. "Measures" or "[Customer].[Customer Geography]" |
| Member1,…, MemberN | Either a single member unique name or an XL3Member formula |
