Skip to Content
avatar image
Former Member

MEMBER ID DISPLAY

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    May 12, 2014 at 01:28 AM

    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


    ID and Desc.png (16.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • 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