EPMolapmembero() defined in Page axis returns what is selected in display of member selector

Feb 15, 2017 at 10:40 AM|1.1k Views

Dear All

I would like to know if anyone has tried to fix the return of the value on the EPMOlapmembero() function to only ID . Instead of what is selected in the selection like : ID or description or ID-Description".

This behavior change is observed from the SP27.

The issue is when the Epmdimensionoverride or axis override funcitons are referenced on the "EpmolapmemberO()" cells then the EPMdimensionoverrides are not working.

If you go to page axis and select multiple members...the formula becomes EPMOLAPMultiMember! To change the behaviour of function to ID's only...Go to edit report..then go to page axis....and now from this member selector...select display as ID's! Click on "OK".

Just tested......with EPM Plug in of AO. Let me know whether its different with SP 27....

I was able to derive using the same for ID selection, Description and now with your formula i am able to derive for ID-Description selection. But the problem is i have so many reports like ~100s to work on this kind of solution. which is a big challenge.

This is the issue we identified when we are upgrading to SP27 from SP20.

My question where i am completely struck is :

Why an EPMcontextmember() always returns IDs even though we select description or ID or ID-Description. ?

Why not the EPMOlapmember() behaves the same way??. Is there any setting or config which is i can change to fix all together without editing or changing anything in the reports/forms in EPM SP27.

Your time and suggestions on my problem is much appreciated. If there is anything you could find on this please provide an info.

Add comment

"Why not the EPMOlapmember() behaves the same way??." - by design of SAP team :)

"Is there any setting or config which is i can change to fix all together
without editing or changing anything in the reports/forms in EPM SP27" - no settings! You can switch to old member selector, but I don't think it will help:

"You can still use the standard historical Member Selector by setting this new configuration key to False: UseWpfMemberSelector."

"I think i need to go to SAP for help" - possible, but don't expect that your issue will be solved in a reasonable time!