As mentioned in the EPM Add-in user guide:
"Empty rows and columns behavior for inserted members. You have selected the Remove Empty option for rows or columns in the Sheet Options. Then, you insert members using the Insert Members dialog box. Some of the inserted members do not have any data. However, they remain in the report as long as you do not refresh the report. "'
In your case, you use the Edit Report button -> Filtering tab to remove empty data.
When you insert members that do not have any data, they disappear in the report although you do not refresh the report.
- SAP BusinessObjects EPM solutions, add-in for Microsoft Office
EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, EPM addin, EPM add in, EPM add-on, EPM add on, member , KBA , EPM-XLS , EPM Excel Client , Problem
About this pageThis 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.