After loading or modifying a hiearchy of a dimension, when you runn reports in the EPM add-in, an error is listed:
In the error detail, you can see some texts like "Sql processing error: Error occurred while executing a MDX statement. The error message is: Cube XXX could not be found","Hierarchy not found in Hierarchy cache","Hierarchy source data:Multiple parent member not allowed: YYYY,ZZZZ"
Sometimes, you can see an ABAP dump in the ABAP system:"Runtime Errors ITAB_DUPLICATE_KEY","ABAP Program CL_UJHANA_MODEL_FORMULA_HELPERCP"
Checking from BPC Adminstration client ->Dimensions ->Display the hierarchy of the dimension, you find the mentioned member in the dimension doesn't have multiple parents.
SAP BusinessObjects planning and consolidation 10.1 ,version for SAP NetWeaver(BPC 10.1 NW);
SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA;
SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA;
KBA , EPM-XLS , EPM Excel Client , EPM-BPC-NW , NetWeaver Version , EPM-BPC-BW4 , BPC/4 , 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.