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.
XL3Member( Connection, Hierarchy, Member1, [Member2],…,[MemberN] )
|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]" )
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]..LastChild" )