Hello,
Given the inability to add member formulas with the syntax found below (per SAP note 2104823) in NW 10.1, what is the recommended "logic script and/or custom BADI" to produce the same results in NW 10.1, as found in 10.0.
*FUNCTION FN_1
IIF([MEASURES].CURRENTMEMBER.NAME=”PERIODIC”,[S90000]*[S90001],0),SOLVE_ORDER=100
*ENDFUNCTION
MEMBER FORMULA:
FN_1
Thanks!
Anthony
cusersanthonybellcourtdocumentsmember-formula-exam.png
Sorry, but this note describe the same issue for all BPC versions, not for 10.1 only.
Please explain in words what do you want to achieve? Not clear from the attached screenshots. And please, attach pictures using "Insert Image" button - hard to read.
Hi Vadim,
Thank you for your response.
Correct, it describes the lack of functionality in all NetWeaver versions to execute the following syntax:
IIF([MEASURES]).CURRENTMEMBER.NAME=”YTD”,1,0),SOLVE_ODER=100
Compared to BPC MS, which has the ability to execute the above syntax (per notes 2104823 & 1400684).
What I want to achieve is this: EPM reporting on a member formula, off the periodic measure (i.e. when the periodic measure is selected), that produces a result based on a calculation of my choosing (as shown in my example IMAGE) versus the periodic measure formula in BW.
I want this to work as it did in MS. Meaning, I am not looking to create custom measures for each instance where I want a different result for the periodic measure calculation (there are too many instances, that many custom measures would be messy. And I still want to report off of the periodic measure for all other ACCOUNT members). I also do not want to duplicate my number of accounts members. For example, S90002_PER will not suffice as an effective solution to supplement for this loss of functionality. Etc.
What sort of logic and/or BADI is being recommended to compensate for the loss of functionality?
Thanks!
EXAMPLE BASED ON FUNCTION FROM ORIGINAL POST
*FUNCTION FN_1
IIF([MEASURES].CURRENTMEMBER.NAME=”PERIODIC”,[S90000]*[S90001],0),SOLVE_ORDER=100
*ENDFUNCTION
MEMBER FORMULA:
FN_1
OK, you can see that this functionality is not supported in BPC NW. No way!
You can use a local member in EPM report referencing the hidden column with values. Easy way!
You can try to create a BADI_UJ_SQE_POST_PROCESS badi to manipulate data after reading from cube. Complex way.
Script logic will not help in your case.
Thank you Vadim. We did see this BADI and now with your recommendation we will look further into the functionality of the BADI.
From your experience, for this specific BADI (BADI_UJ_SQE_POST_PROCESS) do we have the capability to link the BADI to a specific member or member formula? I.E. Is the BADI always called for every report for our selected members (like default logic)? Or is this BADI tied to specific reports?
We have ~75 member formulas where we would need to "manipulate the data" whenever said members are selected for an EPM report.
"From your experience, for this specific BADI (BADI_UJ_SQE_POST_PROCESS) do we have the capability to link the BADI to a specific member or member formula?" - No!
This badi is filtered by Environment and Model only! No members or reports.
Please read:
https://archive.sap.com/documents/docs/DOC-4217
and may be:
https://blogs.sap.com/2013/03/25/ujqsharedquery-to-average-data-in-bpc-reports/
I have already told you - it's a complex way. And to my mind it's not a good idea in general to hide values this way. Something like "creative accounting". I am not able to understand a business case.