MemberProperty

Note:

MemberProperty is applicable to Oracle Hyperion Planning details and Oracle Essbase database connections.

MemberProperty is a text function. Based on the syntax used, it returns the member property value of a dimension in the row, column, page, or Point of View (POV). You can use this function to display a member property in a text row or column.

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

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

• The following syntax returns the member property 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, then select Custom Heading on the property sheet. You can add the function in the space provided below the custom heading.

  <<MemberProperty("DimName", Property)>>

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

  <<MemberProperty("GridName", POV DimName, Property)>>

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.
POV DimName	Name of the dimension on the grid or user POV.
Property	Any custom property (attribute dimensions).

Examples:

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

<<MemberProperty("Grid1", A, Product,Pkg Type)>>

<<MemberProperty(current, A, Product, Pkg Type)>>

Return the member property for the Market dimension. The syntax is placed on the grid’s custom heading:

<<MemberProperty("Market", Population)>>

<<MemberProperty(current, Population)>>

Return the member property for the Market dimension for the POV associated with Grid1:

<< MemberProperty("Grid1", Market, CurrencyCategory) >>

<< MemberProperty(current, Market, CurrencyCategory )>>

Retrieve the Member Alias and Ounces property of a product in a custom heading. (To do this, select the heading, then on the Heading Row Properties sheet, select the Custom Heading option, and then click Functions).

<<MemberAlias(current, current, Product)>>:
<<MemberProperty(current, current, Product, Ounces)>>

The report output would resemble the following:

Note:

MemberProperty only supports the Current keyword when used in a grid cell, not in a text box object, header, or footer. See Using the Current/Cur Keyword in a Text Function.