MemberName

MemberName returns the name of the member assigned to a dimension in the grid row or column.

Syntax:

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

  • The following syntax returns the name 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.

    MemberName ("Dimension")

  • The following syntax returns the name 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.

    MemberName ("Grid", "Dimension")

Note:

See Parameters for Text Functions for parameter definitions.

Examples:

Return the name assigned to the Product dimension in Grid1, column A:

MemberName("Grid1", "Product", A)

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

MemberName("Year")

Return the name for the Scenario dimension for the POV associated with Grid1:

MemberName("Grid1", "Scenario")