SAP Knowledge Base Article - Public

3373456 - Members <root> are inconsistent between master data and hierarchies in SAP Analytics Cloud (SAC)

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

  1. Login to SAC.
  2. Open the model.
  3. Open the dimension.
  4. 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

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