cancel
Showing results for 
Search instead for 
Did you mean: 

MEMBER ID DISPLAY

Former Member
0 Kudos
333

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member190501
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (0)