Symptom
- When clicking "Load all of the members" for a dimension, a new <root> member ID appears in the dimension.
- The validation error says: "Value may not be <root>".
Environment
SAP Analytics Cloud (Entreprise) 2023.16.10
Reproducing the Issue
- Log in to SAP Analytics Cloud
- From the main menu, go to modeler
- Open the model under the Model Structure workspace
- Look for the dimension you would like to work on and open it
- In the Dimension Details pane, click "Load all of the members"
- Note the new <root> Member ID that appears with the validation error that "Value may not be <root>".
Resolution
- This is a known issue that can only be fixed directly on database level by removing invalid entries.
- Please rise a support case under LOD-ANA-ML-MDM component and refer to this KBA.
See Also
- 3373456 - Members <root> are inconsistent between Master Data and Hierarchies 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, Load all of the members, <root>, new member, error, validation. , KBA , LOD-ANA-ML-MDM , Master Data Management , Problem
Product
SAP Analytics Cloud 1.0