| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3MemberChildLookup"
(Created page with 'Returns a name or caption of a child of a given member. ==Syntax== {{Code|XL3MemberChildLookup( Connection, Position, Hierarchy, Member )}} ==Parameters== {| class="wikitable"…') |
(Added categories) |
||
| Line 31: | Line 31: | ||
==See Also== | ==See Also== | ||
* [[Formula Reference]] | * [[Formula Reference]] | ||
| + | |||
| + | [[Category:Formulae]] | ||
| + | [[Category:OLAP Formulae]] | ||
Latest revision as of 10:35, 8 October 2010
Returns a name or caption of a child of a given member.
Syntax
XL3MemberChildLookup( Connection, Position, Hierarchy, Member )
Parameters
| Parameter | Description |
|---|---|
| Connection | Connection number to use |
| Position | Number of child to return |
| Hierarchy | Name of the hierarchy that the member applies to e.g. "Measures" or "[Customer].[Customer Geography]" |
| Member | Member whose child should be returned |
Examples (based on the Bicycle Sales cube)
Returns 'W7000/205', the 2nd child of 'Scenario W7000'
=XL3MemberChildLookup( 1, 2, "Product", "[Product].[Scenario W7000]" )
