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
- Navigate to import model - Data management.
- Select an existing import job.
- 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
- Open the model in SAP Analytics Cloud.
- Access the dimension table.
- In the Dimension Table Details panel, scroll down to the Hierarchies section.
- 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".
- The member "Not in hierarchy" should now be automatically added to the dimension.
- Save the model.
- Run the import job again.
See Also
- 3538178 - Hot Features and Issues in 2024 QRC4 Update of SAP Analytics Cloud(SAC) - Hub KBA - SAP for Me
- https://roadmaps.sap.com/board?PRODUCT=67838200100800006884&range=CURRENT-LAST#Q4%202024;INNO=ED8FED9310D11EEEADA46E6DFDE77A8C
- https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a5af17fec4f1428188ea185a526873c0.html?locale=en-US&q=hierarchies#parent-child-hierarchies-with-not-in-hierarchy-member
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
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