Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 22, 2014 at 10:41 AM

    Why cant you use Position or Members in local member formula instead of cell reference.?

    Add comment
    10|10000 characters needed characters exceeded

    • The reference substitution (from EPMDIM_CURRENT_MEMBER(CATEGORY) to actual - for example B8) is done for the first report only. The second report is using the same relative reference 😊 - same row, current column.

      Vadim

  • Dec 22, 2014 at 08:47 AM

    Hi Mohamed,

    But what is the issue with my solution? In the link you mentioned - column was the shared axis, and you have row shared axis...

    By the way, what is the reason to have multiple reports?

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but looks like none of my answers are useful...

      And about headers - you can hide original column axis headers and create your custom headers using additional local members with the method I explained:

      =IF(EPMReportID(EPMDIM_CURRENT_MEMBER(xxx))="000",...

      Vadim