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.