Skip to Content
avatar image
Former Member

EPMContextMember based on Property is not updating in cell

Hi Everyone,

I have one problem , EPMContextMember based on Property is not updating in cell.

But when i double click on cell i can see desired member.

Can you please suggest me how i can see updated member in cell?

Note: I had done meta data refresh after changing property value

Before double click on cell. the value was FCST201607

After double click on cell. the value is FCST201705 - i am expecting this value should be show in the cell

capture.png (7.6 kB)
capture.png (7.6 kB)
capture.png (26.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 26, 2017 at 05:35 PM

    If you want to get a member with specific property set to X and use it in the page axis of your report:

    1. Start with empty sheet

    2. Create simple default report with all dimensions fixed to some member except EVENT dimension in row axis (single fixed time member in column axis)

    3. Write formula: =EPMDimensionOverride("000";"EVENT";"STATUS=X")

    4. Single line report will have a correct EVENT member after refresh

    5. Add you real report after default and reference the cell of default report (containing EVENT member) in page axis of your real report.

    Read https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/ how to reference cells in page axis.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26, 2017 at 05:23 PM

    "EPMContextMember based on Property is not updating in cell"

    Sorry, but what do you mean???

    EPMContextMember will be updated if you change Context selection for the dimension referenced in the formula or if you double click on cell and select some member.

    But it will never update if the property of the member is changing.

    Filter by property is just a filter for USER selection after double click on the cell with formula, nothing more!

    Add comment
    10|10000 characters needed characters exceeded