MMEMBER.ANAME

MMEMBER.ANAME displays a specified attribute of multiple elements. You select the elements in the Select Element dialog.

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

To select multiple elements click Multiple Selection in the toolbar of the Select Elements dialog.

See Choosing slice elements in Formula and Ad-hoc reports.

The elements which you select are added to an array. The array can be stored in the formula, or in a specified cell. The array is displayed as an aggregated element with the format:[Dimension].[attribute 1, attribute 2...]

If you have an ad-hoc report which displays an attribute of multiple elements, MMEMBER.ANAME is used if you convert the ad-hoc report to a formula report. You use MEMBER.ANAME if the report displays the attributes of individual elements.

See MEMBER.ANAME.

Syntax

=MMEMBER.ANAME("Alias", "Cube", "Dimension", "Attribute Name", "Element Selection", "Aggregated Element")

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

The Element Selection argument can be the unique names of the elements, separated by commas, or an empty string ("").

The Aggregated Element argument can be a cell reference or an empty string. If you specify an empty string, the array is incorporated in the formula. If you specify a cell reference, the array is created in the specified cell.

Examples

This example has an element selection of two elements and specifies a cell reference for the Aggregated Element argument. That is, the array is stored in the specified cell:

("Best Practices OLAP","Sales","[PRODUCT]","ATT2_German","[Product].[All Tires].[Car Tires Summer],[Product].[All Tires].[Car Tires Winter]",$D$2)

Note: Initially, the formula displays #REF in the cell.
  1. Double-click #REF.
  2. Click Multiple Selection in the tool bar of the Select Element dialog.
  3. Select Sommerreifen and Winterreifen and click OK.
  4. The cell which contains the formula displays Sommerreifen, Winterreifen.
  5. Cell D2 displays [Product].[Sommerreifen,Winterreifen]
If you select further elements, they are added to the array in D2 and to the formula. For example, if you open the Select Element dialog and select Transporter Reifen (the German attribute of the Commercial (Van Tires) element):
  • Cell D2 displays Sommerreifen, Winterreifen, Transporter Reifen.
  • The formula displays:=MMEMBER.ANAME("Best Practices OLAP","Sales","[PRODUCT]","ATT2_German","[PRODUCT].[All Tires].[Car Tires Summer],[PRODUCT].[All Tires].[Car Tires Winter],[PRODUCT].[All Tires].[Commercial (Van Tires)]",$D$2)

This example specifies an empty string as the value of the Aggregated Element argument. That is, the array is stored within the formula:

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

As you select elements in the Select Element dialog, they are added to the array in the formula. For example, if you select Sommerreifen, Winterreifen and Off-Road Reiffen, the formula displays:

=MMEMBER.ANAME("Best Practices OLAP","Sales","[PRODUCT]","ATT2_German","[PRODUCT].[All Tires].[Car Tires Summer],[PRODUCT].[All Tires].[Car Tires Winter],[PRODUCT].[All Tires].[SUV (4x4)]","[PRODUCT].[Sommerreifen,Winterreifen,Off-Road Reifen]")

This example uses an empty string as the value of the Element Selection argument:

=MMEMBER.ANAME($B$4,$B$5,"[PRODUCT]","ATT2_German","""",$D$2)

The cell displays #REF.

If you select Sommerreifen and Winterreifen in the Select Element dialog:

  • Cell D2 displays [Product].[Sommerreifen,Winterreifen]
  • The formula displays: =MMEMBER.ANAME($B$4,$B$5,"[PRODUCT]","ATT2_German","[PRODUCT].[All Tires].[Car Tires Summer],[PRODUCT].[All Tires].[Car Tires Winter]",$D$2)
Parent topic: Formulas