Local Members Attached to Shared / Multiple Reports
I am trying to use local member that reference to cell in the shared report by row axis , by the value of the formula don't get updated correctly for the second report 001.
for the second report should display 001. I am using EPMReportID in to check to get report ID then I use a formula to get property.
the same issue if I use this formula : =EPMMemberProperty(, EPMMemberID(I8), "PARENTH1")
the members in the column axis are dynamic , means based on some selections, I use EPMAxisOverride to changes the members.
I tried to apply the solution adviced by Vadim in the discussion: http://scn.sap.com/thread/3640499 but its not getting updated for me.
may I miss something.
I find also a SAP Note : 1996732 - Local Members Attached to Shared / Multiple Reports
Please find in attach the scenario that I am testing .
Thank you for your help.
Vadim Kalinin replied
Ok, then use the following:
EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY), "CATEGBS"))
You have to use CATEGORY instead of SALES!!!! The reference will be calculated using report "000" and used in second! This was mentioned in my original post...