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: