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 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:

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:

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 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")

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")

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.