Members shown as Dimension:xx for xx in EVDRE
I have made few applications in SAP BPC 7.50.5 NW, it has few dimensions including distribution channel and division. The values of these are numeric like 10,20,30,40 etc. when I created EVDRE reports, it shows the key like P_DISTCHNL:30 and P_DIVISION:10 and not 30 and 10. I have changed the format in member sheet maintenance to text/general/number but every time it shows the same thing with dimension name as prefix. Only for one or two members it is actually showing the member as 90 and not P_DISTCHNL:90.
I have also deleted and recreated the dimensions but it also did not help.
Can you please help me on that.
As a work around,for some of my dynamic selection in EVDRE, i am making use of Right(member cell,2) to get the value. but this might pose some issues in scriptlogic in future.
Thanks & Regards