Skip to Content

Member ID and desc in separate columns

Hello experts

I have a requirement that I need to show id and description in separate columns. In case of Cost centre - CC_110001- IT_Japan, the ID is CC_110001 and description is IT_Japan.I prefer not to have a local member.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 04 at 08:38 PM

    Is it so hard to open help for EPM Add-In?

    https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.30/en-US/f9bdca036faf1014878bae8cb0e91070.html

    To get Member ID:

    =EPMMemberProperty(,EPMDIM_CURRENT_MEMBER(COST_CENTER),"ID")

    To get Description:

    =EPMMemberDesc(EPMDIM_CURRENT_MEMBER(COST_CENTER))

    And hide column with COST_CENTER axis.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 02:29 PM

    You have to use local members! But what is the issue???

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07 at 12:17 PM

    Thanks a lot Vadim

    Add comment
    10|10000 characters needed characters exceeded