EPMContextMember based on Property is not updating in cell

[former_member398742]

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

[former_member186338]

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

EPM Add-In for Excel

[former_member186338]

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.

[former_member186338]

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