MEMBER.ANAME

MEMBER.ANAME displays a specified attribute of an element. You select the element in the Select Elements dialog.

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

If you have an ad-hoc report which displays individual element attributes, MEMBER.ANAME is used if you convert the ad-hoc report to a formula report.

MMEMBER.ANAME is used if the report contains multiple selections of elements.

Syntax

=MEMBER.ANAME("Alias", "Cube", "Dimension", "Attribute Name", "Element")

The Alias and Cube arguments can be the cell references of cells which contain the alias and cube names.

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

Examples

This formula displays: Sommerreifen, the German attribute of the Car Tires Summer element:

=MEMBER.ANAME("Best Practices OLAP", "Sales", "[PRODUCT]", "ATT2_German", "[Car Tires Summer]")

This formula displays All Reifen Gesamt, the attribute of the default element of the Product dimension (All Tires):

=MEMBER.ANAME("Best Practices OLAP", "Sales","[PRODUCT]","ATT2_German","")