Skip to Content
0

EPMContextMember based on Property is not updating in cell

Apr 26, 2017 at 04:57 PM

140

avatar image

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)
10 |10000 characters needed characters left characters exceeded

Strange idea to use both tags for BPC NW and BPC MS... And not to use correct tag

EPM Add-In for Excel

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Apr 26, 2017 at 05:35 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Apr 26, 2017 at 05:23 PM
0

"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!

Share
10 |10000 characters needed characters left characters exceeded