Returns a name or caption for a member. The member is retrieved from a cube cell so can be calculated using MDX formulas.
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 formulas.
If you want the result of a look-up to be a member, you need the value to be returned before the other formulas are evaluated. 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 for example, "Measures" or "[Customer].[Customer Geography]". |
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the following member applies to for example, "Measures" or "[Customer].[Customer Geography]". |
| Member1,…, MemberN | Either a single member unique's name or an XL3Member formula. |
