1884531 - EPM Add-In report does not change when a dimension member is manually entered

A report is created with at least one row and column but no page axis. Then a dimension is added to the page axis by dragging and dropping the dimension into the Page Axis section of the EPM Add-In report definition pane - this produces a cell with a formula similar to "= EPMOlapMemberO("[YEAR].[H1].[2013]";"";"2013";"";"000"). The report definition is now correct.

When the Page Axis cell is manually edited to enter a valid value for the dimension, e.g. "2014", then the underlying function in the cell disappears, the dimension is removed from the Page Axis definition, and the report refresh does not show the correct data.

Other methods may be used to enter values into the cell, for example by using an EPM function such as =EPMPropertyValue, this issue also occurs.

Read more...

• EPM Add-In 10.0 (all Service Packs and Patches)
• SAP Business Planning and Consolidation 10.0 version for the Microsoft platform
• SAP Business Planning and Consolidation 10.1 version for the Microsoft platform

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Financial Consolidation 10.0

EPM, BPC MS, Business Planning and Consolidation for Microsoft, SAP BPC FOR Microsoft, report,page axis,dimension member,disappears,not recognized,recognize,recognised,changes,epm addin,excel client,worksheet,axis,axes,epmolapmembero , KBA , EPM-BPC-MS , Microsoft Version , EPM-XLS-OPT , EPM XLS Options , How To