| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3MemberLookup"
(→Parameters) |
(Added categories) |
||
| Line 55: | Line 55: | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
* [[XL3Member|XL3Member formula]] | * [[XL3Member|XL3Member formula]] | ||
| + | |||
| + | [[Category:Formulae]] | ||
| + | [[Category:OLAP Formulae]] | ||
Latest revision as of 10:35, 8 October 2010
 |
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 )
