SAP Knowledge Base Article - Preview

3085388 - Inserted members disappear in the report when used with the data filtering feature - EPM Add-in


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 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.