MMEMBER.NAME
With MMEMBER.NAME, you select several elements from a hierarchy. You select the elements from the Select Element dialog. The formula generates a calculated element that aggregates the selected elements and displays the unique name. Double-click the cell which contains formula, to open the Select Element dialog.
Syntax
=MMEMBER.NAME(Alias,Cube,Dimension,Multiple Element Selection,Aggregated Element)
Note: Initially, the formula displays #REF in the cell.
Example
To select elements from the [Product] dimension, use the MMEMBER.NAME formula:
=MMEMBER.NAME("Best Practices OLAP","Analysis","[Product]",””,””)
The cell that contains the formula displays #REF. Double-click the cell to select other elements in the Select Element dialog.