SAP Knowledge Base Article - Public

3542695 - SAP Analytics Cloud - Import Job Failure due to Missing Hierarchical Member

Symptom

  • After QRC4 update, an import job in SAP Analytics Cloud (SAC) fails with the error message: "Failed to upsert dimension members in dimension XXXXX. Please contact your company administrator with the following error code (MI_UDM)".
  • Error under System > Monitor > trace: "previous":{"packageId":"sap.fpa.services.resource.modeling","objectName":"message_hierarchy","messageId":"REST_NODE_MISSING_IN_MASTER_DATA","args":["Not In Hierarchies"],"message":"The non-hierarchical member [Not In Hierarchies] is missing in the master data. Please add the member manually."}

Environment

  • SAP Analytics Cloud (Enterprise) 2024.21.7 

Reproducing the Issue

  1. Navigate to import model - Data management.
  2. Select an existing import job.
  3. Observe the error message: "Failed to upsert dimension members in dimension XXXXXX. Please contact your company administrator with the following error code (MI_UDM)".

Cause

  • The dimension mentioned in the error message has a Parent-child hierarchy with not-in-hierarchy member.
  • the Group and show under "Not in Hierarchy" option is selected but the "Not In Hierarchy" member is missing from dimension.
  • This is a new QRC4 feature: For parent/child hierarchies enforcing this condition, "<root>" will default where a specific parent is not provided SAP Road Map Explorer. 

Resolution

  1. Open the model in SAP Analytics Cloud.
  2. Access the dimension table.
  3. In the Dimension Table Details panel, scroll down to the Hierarchies section.
  4. Update the Empty Hierarchy Values setting:
  • First, set it to Remove from Hierarchy.
  • Then, set it back to Group and Show under "Not in Hierarchy".
  1. The member "Not in hierarchy" should now be automatically added to the dimension.
  2. Save the model.
  3. Run the import job again.

See Also

Keywords

SAP Analytics Cloud, import job, failure, dimension members, hierarchical data, missing member, Not in Hierarchies, MI_UDM, error code, import validation, Empty Hierarchy Values, update setting. , KBA , LOD-ANA-ML , SAC Modelling , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0