MEMBER ID DISPLAY

[Former Member]

EPM 10 - NW

In my reports on the column axis and row axis I am seeing "MEMBER ID - Description"

Is it possible to configure report to display "Member ID" in axis after expansion without description. Where and how?

Also is it possible to display "MEMBER ID - Description" or "MEMBER ID" based on its level

-Dilkins

[former_member190501 · Accepted solution]

Hi,

Goto Edit report -->click on Dimension --> you can choose options as below.

Using local member (excel functions) you can show ID or ID-Desc based on level of the hierarchy.

Thanks,

Raju

[former_member186338 · Accepted solution]

Some example of local member formula:

=IF(VALUE(EPMMemberProperty(,EPMMemberID(EPMDIM_CURRENT_MEMBER(ACCOUNT)),"HLEVEL"))=6,EPMMemberProperty(,EPMMemberID(EPMDIM_CURRENT_MEMBER(ACCOUNT)),"ID")&" "&EPMMemberProperty(,EPMMemberID(EPMDIM_CURRENT_MEMBER(ACCOUNT)),"Description"),EPMMemberProperty(,EPMMemberID(EPMDIM_CURRENT_MEMBER(ACCOUNT)),"ID"))

Vadim