SAP Knowledge Base Article - Preview

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.



  • EPM Add-In 10.0 (all Service Packs and Patches)
  • SAP Business Planning & Consolidation 10.0 (all Service Packs and Patches)


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


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.