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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.