3277107 - Error [6990] Hierarchy source data: Multiple parents not allowed while refreshing or creating a BPC report

• When creating or refreshing a report via EPM add-in or BPC web, below error occurs.
  

  code: UJHANA_SQE_EXCEPTION_007
  severity: error
  description: Run SQE HANA query fail
  log id: 051MYLrZ7jsSbQ66uFUyVG

  -----------------code: UJHANA_SQE_EXCEPTION_004
  severity: error
  description: Create hierarchy table error
  log id: 051MYLrZ7jsSbQ66uFUyVG

  -----------------code: _000
  severity: error
  description: A database error occured. The error message in the database was: "column store error: search table error:  [6990] Hierarchy source data: Multiple parents not allowed: -XX, -YY".
  log id: 051MYLrZ7jsSbQ66uFUyVG

  -----------------

  Framework message:
  The remote server returned an error: (400) Bad Request.

  The remote server returned an error: (400) Bad Request.

• The issue may occurs after you create a new hierarchy for a dimension or enables time dependent hierarchy. 

• SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
• SAP Business Planning and Consolidation 11.X, version for SAP BW/4HANA 
• SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

inconsistency, SID, duplicate, duplicated, HANA view , KBA , EPM-BPC-BW4-INF-SQE , BPC/4 - Shared Query Engine , EPM-BPC-NW-SQE , Shared Query Engine , Problem