Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Local Members Attached to Shared / Multiple Reports


Hi,

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.

Regards

Mohamed Faouzi

Former Member
replied

Ok, then use the following:

=IF(EPMReportID(EPMDIM_CURRENT_MEMBER(CATEGORY))="000",

EPMMemberProperty(, EPMDIM_CURRENT_MEMBER(CATEGORY),"CATEGAT"),

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

Vadim

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question