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

Hi Mayank,

I guess this is an old behaviour of this function.....Check here....http://help-legacy.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf Referencing an EPMOlapMemberO Page no. 279.

Try to use EPMMemberId function with this function.

Regards,

JP

EPMOlapMemberO function in the page axis will always show the member based on selection like : ID or description or ID-Description

You have to use (assuming that EPMOlapMemberO is in A1):

=EPMMemberProperty(; EPMMemberID(A1); "ID")

To get only ID independent on selection.

Dear Vadim

"EPMOlapMemberO function in the page axis will always show the member based on selection like : ID or description or ID-Description" is happening from EPM SP27. earlier in SP20 this was not there.

As you suggested, =EPMMemberProperty(; EPMMemberID(A1); "ID") will work if user selects a single member and we tried this it is working good.

But here our complexity is increased because the users are selecting multiple members and multiple descriptions are creating a problem.

We have so many impacted because alot of references and VB is used looking at the "A1" cell ( Epmolapomember)...

Thanks again in advance.

Dear Vadim,

Apologies for that, I was in a mindset/thought process to get/return the output of the "EpmOlapmemberO" function to "IDs Only".

and i was also searching is there any changes in the Config dll file will enable or force to return only IDs with the selection.

Apologies agian. Thanks

Mayank,

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....

Here is the selection how it looks for multiplemember selection on EPM SP27

Dear Vadim,JP

Thanks again.

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.

I think i need to go to SAP for help.

Thanks again for your support.

MG

Dear Vadim

Thank you so much for your valuable suggestions and time.