MemberAlias

MemberAlias is a text function. Based on the syntax used, it returns the alias of the member assigned to a dimension in the row, column, or Point of View (POV).

Syntax

MemberAlias("Grid", "Dimension", Row/Col, Qualified)

• The following syntax returns the alias of a row or column heading. The syntax can be deployed from any heading cell, text cell, or text box object and can reference any grid in a current report.

  MemberAlias ("Dimension")

• The following syntax returns the alias of a POV. The syntax can be deployed from any text cell or text box object and can reference any grid and corresponding POV in a current report.

  MemberAlias ("Grid", "Dimension")

Note:

See Parameters for Text Functions for parameter definitions.

Examples:

Yield the alias Diet Root Beer, which is the alias that is assigned to the Product dimension in Grid1, column A:

MemberAlias("Grid1", "Product", A)

Yield the alias for the Year dimension. The syntax is placed on the grid’s custom heading:

MemberAlias("Year")

Yield the alias for the Scenario dimension for the POV associated with Grid1:

MemberAlias("Grid1", "Scenario")