Symptom
- Not able to add any new member in the dimension.
- When adding any new member in the dimension, it is throwing an error: Members [<root>] are inconsistent between master data and hierarchies.
Environment
SAP Analytics Cloud Version:
2024.2.10 (Client)
2024.2.8 (Server)
Reproducing the Issue
- Login to SAC.
- Open the model.
- Open the dimension.
- Add a new member.
Notice that it throws the error: Members [<root>] are inconsistent between master data and hierarchies.
Cause
There is an invalid database table entry having a node ID of '<root>' which is not allowed.
Resolution
- This is a known issue that can only be fixed directly on database level by removing invalid entries.
- Please raise a support case under LOD-ANA-ML-MDM component and refer to this KBA.
See Also
- 3398820 - New <root> member ID appears in the dimension with the validation error that "Value may not be <root>" in SAP Analytics Cloud
- 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 case for SAP Analytics Cloud?
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
SAC, SAP Analytics Cloud, model, Dimensions, <root>, error, validation, inconsistent, Master, Hierarchies. , KBA , LOD-ANA-ML-MDM , Master Data Management , Problem
Product
SAP Analytics Cloud 1.0