SAP Knowledge Base Article - Preview

2772634 - Empty values for alternative hierarchies in EPM Add-in


You have more than 10 hierarchies defined for a dimension.

When you display data in the EPM Add-in, the value of PARENTH1 is displayed correctly.
However, the value of other hierarchies is shown as empty.

If you right click the cell and choose "Refresh selected data", "The remote server returned an unexpected response: (400) Bad Request" error appears.
An exception is recorded in SLG1 log too.

In addition, the hierarchy in the EPMOlapMemberO formula is not correct.
For example, member CN belongs to PARENTH11, but the formula in EPM Add-in is =EPMOlapMemberO("[ENTITY].[PARENTH2].[CN]","","CN - China","","000").



  • SAP Business Planning and Consolidation, version for SAP NetWeaver


SAP Business Planning and Consolidation, version for SAP NetWeaver all versions


EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, PARENTHx, PARENTH, hierarchy, no data, no result , KBA , reporting , EPM-BPC-NW-ADM-DIM , Dimension Management , 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.