SAP Knowledge Base Article - Public

3579818 - Fail to import data to public dimension with hierarchy

Symptom

  • Error in job status: "An unexpected error occurred while trying to update the dimension data."
  • Error in HAR trace: "The parent of [xxx] doesn't exist in the same hierarchy. Please add the parent to the hierarchy, or select another parent."

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Create the import job.
  2. Configure the data mapping with proper hierarchy.
  3. Run the import job, it fails.

Cause

The parent of this member xxx doesn't exist in a hierarchy. Assuming this member xxx belongs to two hierarchies(HieA and HieB) and for each hierarchy it has a parent ParA and ParB. However by checking this the parent, the ParB doesn't exist in HieB, so this hierarchy data is not consistent.

Resolution

Add the missing data to complete the hierarchy structure.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

KBA , LOD-ANA-ML-MDM , Master Data Management , Problem

Product

SAP Analytics Cloud all versions