MEMBER.CNAME

MEMBER.CNAME displays the caption of a selected element. You select the element in the Select Elements dialog.

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

MEMBER.CNAME and MMEMBER.CNAME formulas are used to return values when an ad-hoc report is to a formula report.

Which formula is used depends on whether a single element, or multiple elements were selected from the dimension in the ad-hoc report.

Syntax

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

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

This example returns Summer Tires, the caption of the Car Tires Summer element:

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