MEMBERCNAME
Returns the caption of an element. In View Mode, double-click an element returned by the MEMBERCNAME function to open the Select element dialog. You can also use the action 'Select element' .
See Actions.
Syntax
=MEMBERCNAME("database alias","cube", "dimension", "element")
Example
=MEMBERCNAME("Best Practices OLAP","Sales","[Product]","[Product]. [Car Tires All Season]")
Multiselect
MEMBERCNAME supports multiselect. That is, you can use it to return the captions of multiple elements that are stored in MLS-XML.
For example, a report variable called rv_multi contains this MLS-XML:
<?xml version="1.0" encoding="utf-16"?> <MultiSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Hierarchy>[Period]</Hierarchy> <AggregationFunction>Sum</AggregationFunction> <StructureSelection> <Member> <MemberUName>[period].[all years].[2002]</MemberUName> </Member> <Member> <MemberUName>[period].[all years].[2003]</MemberUName> </Member> </StructureSelection> </MultiSelect>This MEMBERCNAME formula returns: 2002, 2003.
Other formulas that support multiselect are: