Symptom
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...
Environment
- 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
Product
Keywords
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
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.