| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3Member"
(Created page with 'Returns a name or caption for a member or members. Multiple members can be specified (as separate parameters) to allow a multi-member set to be used. Use the {{Menu|Insert Formu…') |
m (Moved link to XL3Lookup to the first time it's mentioned.) |
||
| Line 32: | Line 32: | ||
You can specify multiple members for an {{Code|XL3Member}} formula by using additional parameters. | You can specify multiple members for an {{Code|XL3Member}} formula by using additional parameters. | ||
| − | ''When referred to by an {{Code|XL3Lookup}} formula, it returns the sum of Allround and Mountain Bikes.'' | + | ''When referred to by an {{Code|[[XL3Lookup]]}} formula, it returns the sum of Allround and Mountain Bikes.'' |
{{Code|1==XL3Member( 1, "Product", "[Product].&[Allround]", "[Product].&[Mountain]" )}} | {{Code|1==XL3Member( 1, "Product", "[Product].&[Allround]", "[Product].&[Mountain]" )}} | ||
| Line 38: | Line 38: | ||
===XL3Member using MDX=== | ===XL3Member using MDX=== | ||
| − | You can specify an MDX calculation for members using the {{Code|MDX:}} syntax. These cells can then be referenced by | + | You can specify an MDX calculation for members using the {{Code|MDX:}} syntax. These cells can then be referenced by {{Code|XL3Lookup}} formulae to use the created calculated members. |
''The last month in 2005.'' | ''The last month in 2005.'' | ||
{{Code|1==XL3Member( 1, "[Time]", "MDX:[Time].[All].[2005].LastChild" )}} | {{Code|1==XL3Member( 1, "[Time]", "MDX:[Time].[All].[2005].LastChild" )}} | ||
Revision as of 09:34, 6 October 2010
Returns a name or caption for a member or members. Multiple members can be specified (as separate parameters) to allow a multi-member set to be used.
Use the Insert Formula > Members menu or ribbon item to insert the formula using a wizard.
Contents
[hide]Syntax
XL3Member( Connection, Hierarchy, Member1, [Member2],…,[MemberN] )
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]" |
| Member1,…, MemberN | Members to use |
Examples (based on the Bicycle Sales cube)
Member name 'W6000/185'
=XL3Member( 1, "Product", "[Product].&[W6000/185]" )
Multiple Members
You can specify multiple members for an XL3Member formula by using additional parameters.
When referred to by an XL3Lookup formula, it returns the sum of Allround and Mountain Bikes.
=XL3Member( 1, "Product", "[Product].&[Allround]", "[Product].&[Mountain]" )
XL3Member using MDX
You can specify an MDX calculation for members using the MDX: syntax. These cells can then be referenced by XL3Lookup formulae to use the created calculated members.
The last month in 2005.
=XL3Member( 1, "[Time]", "MDX:[Time].[All].[2005].LastChild" )
