| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3MemberLookup
 |
This formula has been superseded by XL3Member. |
Returns a name or caption for a member or members.
Contents
[hide]Syntax
XL3MemberLookup( Connection, Hierarchy, Member, [Format] )
Parameters
| Parameter | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Connection | Connection number to use | ||||||||
| Hierarchy | Name of the hierarchy that the member applies to e.g. "Measures" or "[Customer].[Customer Geography]" | ||||||||
| Member | Comma-delimited list of members to use for the cross section | ||||||||
| Format | Defines the format of the caption.
|
Examples (based on the Bicycle Sales cube)
Member name 'W6000/185'
=XL3MemberLookup( 1, "Product", "[Product].&[W6000/185]" )
Unique member name [Product].&[W6000/185]
=XL3MemberLookup( 1, "Product", "[Product].&[W6000/185]", 3 )
Multiple Members
You can specify multiple members for the Member parameter by separating them with a comma.
When referred to by an XL3Lookup formula, it returns the sum of Allround and Mountain Bikes.
=XL3MemberLookup( 1, "Product", "[Product].&[Allround],[Product].&[Mountain]", 0 )
