MEMBER.NAME

MEMBER.NAME displays the unique name of an element which you select in the Select Elements dialog.

To open the Select Elements dialog, double-click the cell which contains the formula.

Syntax

=MEMBER.NAME(Alias,Cube,Dimension,Element)

The Element argument can be a unique name or an empty string (""). If you specify an empty string, the formula displays the unique name of the default element.

Example

This example returns the unique name of the Car Tires Summer element:

=MEMBER.NAME("Best Practices OLAP","Sales","[product]","[Product].[All Tires].[Car Tires Summer]")

Related topics