| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3MemberLookup"
(Created page with '{{Deprecated Formula|XL3Member}} Returns a name or caption for a member or members. ==Syntax== {{Code|XL3MemberLookup( Connection, Hierarchy, Member, [Format] )}} ==Parameter…') |
(Added categories) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 22: | Line 22: | ||
|- | |- | ||
| {{Code|Format}} | | {{Code|Format}} | ||
| − | | Defines the format of the caption | + | | Defines the format of the caption. |
| + | {| | ||
| + | | 0 || Member caption (default) | ||
| + | |- | ||
| + | | 1 || Parent caption | ||
| + | |- | ||
| + | | 2 || Member caption with Ancestors | ||
| + | |- | ||
| + | | 3 || Member unique name | ||
| + | |} | ||
|} | |} | ||
| Line 46: | 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 )
