1. User's Guide
  2. Using Functions
  3. Text Functions
  4. MemberDescription

MemberDescription

Note:

MemberDescription is available only with Oracle Hyperion Financial Management as the database connection

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

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

    <<MemberDescription( "GridName", Row/Col/Page, "DimName")>>

  • The following syntax returns the description in a row heading, column heading, or page. The syntax can be deployed from any row, column, or page heading in a grid that is designated as a custom heading. To designate a custom heading, click the page, row heading or column heading, and then select Custom Heading on the property sheet. You can add the function in the space provided below the custom heading.

    <<MemberDescription( "DimName")>>

  • The following syntax returns the description of a grid or user 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.

    <<MemberDescription( "GridName", "POV DimName")>>

Argument Description
GridName Name of the grid.
Row/Col/Page Numeric identifier of the row, the alphabetical identifier of the column, or the numeric identifier of the page.
DimName Name of a dimension in the grid row, column, or page.
POV DimName Name of the dimension on the grid or user POV.

Examples:

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

<<MemberDescription("Grid1", A, "Product")>>

<<MemberDescription(current, A, "Product")>>

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

<< MemberDescription(" Year ")>>

<< MemberDescription(Current)>>

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

<< MemberDescription(" Grid1 ", " Scenario " )>>

<< MemberDescription(current, " Scenario ")>>

Note:

MemberDescription only supports the Current keyword when used in a grid cell or in a text box object when specifying the Page dimension parameter. Other parameters (Grid, Row, Column) are not supported in a text box object, header, or footer. See Using the Current/Cur Keyword in a Text Function.