MemberProperty

MemberProperty returns the member property value of a dimension member in the row, column or Point of View (POV). You can use this function to display a member property in a text row or column or in a text box.

Syntax:

MemberProperty("Grid", "Dimension", Row/Col, "Property" )

Property can be any of the following:

  • attribute dimensions ( for example, "Pkg Type") – associated attribute dimension member

  • UDA - User-defined attributes

    Note:

    • For Essbase data sources, if there are multiple UDAs associated with a member, only one UDA is displayed using the MemberProperty text function.

    • For Oracle Enterprise Performance Management Cloud data sources you can insert an optional index parameter to return specific UDAs, if there are multiple UDAs associated with a member. The syntax is as follows: MemberProperty("Grid", "Dimension", Row/Col, "UDA", (index number))

  • Generation

  • Level

  • IsExpense - a true/false field that signifies if an account type is an expense type or not

  • AccountType - Expense or Non-Expense for Essbase data sources; or Revenue, Expense, Asset, Liability, Equity, or Non-Expense for other EPM Cloud data sources

  • Description - member description for EPM Cloud data sources

  • Alias Table – alternate alias table name to display for a member

  • Base Currency - for Financial Close and Consolidation data sources, displays the Entity Currency

Note:

See Parameters for Text Functions for parameter definitions.

Examples:

Return Associated Attribute members for a member:

Return the "Pkg Type" associated attribute member for the Product dimension member in the current row. The syntax is placed in a text cell in the same row as the Product member

MemberProperty("Product", "Pkg Type")

The result is as follows:


The table describes the MemberProperty function which contains package type information.

Return All UDAs for a member:

Return the UDAs for the Market dimension member in the current row. The syntax is placed in a text cell in the same row as the Market member:

MemberProperty("Market","UDA"):

The result is as follows:


This table contains cola, 5096 in row 1, diet cola, 1359 in row 2, and caffeine free cola, 593 in row 3

Return a specific UDA for a member:

Return a specific UDA for the Product dimension member in the current row. The syntax is placed in a text cell in the same row as the Market member.

If there are two UDAs associated with a member ("Major Product" and "Market Leader"), the following text function syntax will return the first UDA ("Major Product"):

MemberProperty("Product", "UDA", (1) )

The result is as follows:

return specific UDA member

Return other properties for a member:

Return the Generation, Level and IsExpense properties for a Measures member in the current row. The syntax is placed in text cells in the same row as the Measures member:

MemberProperty("Measures", "Generation")

MemberProperty("Measures", "Level")

MemberProperty("Measures", "IsExpense")


The table describes the MemberProperty function which contains Generation, Level and IsExpense details

Note:

If you use MemberProperty in a grid cell but you do not specify a row or column, the current row or column is used by default.

Return the alternate alias for a member:

Return the alias for a member using an alternate alias table for the current Product member in the row.

The syntax is placed in the text column in the same row as the Product member:

MemberProperty("Product", "GermanNames")


alternative alias member

Note:

If you use MemberProperty in a grid cell but you do not specify a row or column, the current row or column is used by default.