Member ID and desc in separate columns

[former_member244687]

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

[former_member186338 · Accepted solution]

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

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

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.

[former_member244687]

Thanks a lot Vadim

[former_member186338]

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

[former_member244687]

Thanks for the reply Vadim .

I am facing performance issue on this report , it would be helpful if I can do without local members. What all are my options

[former_member186338]

Only local member if you have dynamic report.

[former_member244687]

Ok I understand, what would be the solution in that case of local members. thanks