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.
Please provide your insights .
Thanks
Theoretically it's possible to extract MEMBER ID's from EPMOlapMultiMember formula:
The key is FORMULATEXT function!
The member list will be correct for any selection: ID, Description, ID - Description!
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....
The bug found!
If description contain Cyrillic characters then the page axis is not shown!
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
Add comment