Symptom
Importing Account Hierarchy from BW results inconsistent number of rows loading into SAC Planning model.
Some of the rejected rows with below error message:
- Must be leaf node in hierachy
- Data cannot be imported to new non-leaf node
Environment
SAP Analytics Cloud 2023.8.18
Reproducing the Issue
- Go to model->Data management
- Select a NEW Query from BW.
- Grep some dimensions into Panel.
- Set the Hierarchy and specify the drill number as 7, then save it.
- Edit the query and run the job, it shows less records.
- Some of the records get rejected with unknown reasons.
Cause
This issue is currently under investigation of development team.
Resolution
This issue is currently under investigation of development team.
Keywords
- 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.
- 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!
Product
SAP Analytics Cloud all versions