Show TOC

EPMMemberIDLocate this document in the navigation structure

This function retrieves the unique name of a specified dimension member that is included in a report.
Note EPMMemberID must reference a cell that contains an EPMOlapMemberO or EPMOlapMemberC formula.

A unique name includes the following: [dimension name].[hierarchy name].[member name]

Parameter Description
member Cell that contains a member for which you want to retrieve the unique name, that is an EPMOlapMember or an EPMOlapMemberO. Mandatory.

Example

In cell A1, we have: =EPMMemberID(B4)

In cell B4, we have: = EPMOlapMemberC("[YBAC_CO COMPANY_SECURITY].[GROUP_1 0HIER_NODE]";"";"GROUP_1";"";"000")

In cell A1, the result displayed is: [YBAC_CO COMPANY_SECURITY].[GROUP_1 0HIER_NODE]