on 01-03-2018 9:07 AM
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
Is it so hard to open help for EPM Add-In?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to use local members! But what is the issue???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.