MemberQualifiedName

MemberQualifiedName is a text function for use with Oracle Essbase data sources. Based on the syntax used, it returns the qualified name of a non unique member assigned to a dimension in the row, column, page, or Point of View (POV). A non unique member is a child of multiple parents.

Note:

This function is supported only for Oracle Essbase 9.0 or later releases.

For example, if a member named 100 that is a child of the Product1 member and the Product 2 member, then 100 is a non unique member name. The MemberQualifiedName function shows the qualified names in reports. The qualified member names in this example are [Product1].[100] and [Product2].[100].

The following syntax returns the name 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.
<<MemberQualifiedName(“GridName”, Row/Col/Page, “DimName“)>>
The following syntax returns the qualified name 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.
<<MemberQualifiedName("DimName")>>
The following syntax returns the name 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.
<<MemberQualfiedName(“GridName“, “POV DimName“)>>

where:

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

Example:

The following examples yield the qualified non unique name that is assigned to a the Product dimension in Grid1, column A:

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

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

The following examples yields the name for the Year dimension. The syntax is placed on the grid’s custom heading:

<<MemberQualifiedName("Year")>>

The following examples yields the qualified non unique name for the Scenario dimension for the POV associated with Grid1:

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

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

Note:

This function only supports the Current keyword when used in a grid cell; not in a text box object, header, footer or otherwise. For information and examples, see Current / Cur Keyword.