Symptom
Public Dimension Hierarchy disappears in SAP Analytics Cloud (SAC)
Environment
- SAP Analytics Cloud (Enterprise) 2020.21
Reproducing the Issue
1. Create a new "generic" public dimension
2. Save it
3. Go to "Data Management area"
4. Import data from a file
5. Select the file (use first row as column headers)
5b. Click "Import" Button
6. Map "member" to Dimension ID and "description" to Description
7. Click "Finish Mapping" and the next "Finish" Button
8. Wait for the data to be imported
9. Exit the dimension editor
10. Edit the public dimension
11. Under Dimension Settings, create a new Parent-Child Hierarchy
12. Make its ID "Hierarchy1", click done
13. Save the dimension
14. Click "Data Management"
15. Import data from file
16. Select another file (use first row as column headers)
17. Click import
18. Map "memberid" to "Dimension ID" and "parentId" to "Hierarchy1". UN-MAP description if it was auto-mapped
19. Click "Finish Mapping" and the next "Finish" Button
20. Wait for the file to be imported
21. Exit the dimension editor
22. Edit the public dimension
23. Likely row #2 is highlighted red as the Dimension ID and Hierarchy1 have the same entry of <root>
24.Select and delete the invalid row
25. Click Save (note the hierarchy column still has data)
26. Exit the Dimension editor
27. Edit the public dimension
28. ISSUE REPRODUCED: Hierarcy1 column no longer has data!!!
Cause
SAC uses <root> in the UI to indicate that a node is a root node.
Resolution
Don't use in your excel sheet <root> to indicate that a member is a root and just leave the column empty.
See Also
- 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 case for 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.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-ML , SAC Modelling , Problem