Symptom
- Unable to import data into non-leaf members in the new planning model in SAP Analytics Cloud(SAC)
- Error "Must be leaf node in hierarchy"
- Toggle "Conditional Validation" in Job Settings -> Validation Settings is off
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Create a Planning model with the new type.
- Create some dimensions, measures and one parent-child hierarchy.
- Input data into non-leaf members.
- Turn off the toggle Conditional Validation.
- Error "Must be leaf node in hierarchy" shows.
Cause
- For planning models, by default, the fact data is not allowed to be imported to non-leaf nodes of a hierarchy.
- The option Conditional Validation means that if it is not enabled, the default behavior above is applied to all hierarchies in this model.
- When it is enabled, the selected hierarchies will still follow the default behavior but the data can be imported to non-leaf nodes of the unselected hierarchies.
Resolution
- Enable Conditional Validation.
- Unselect the hierarchies where you want to import data into non-leaf members.
- Save it and revalidate it.
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?
- 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.
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
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, sap analyst cloud , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , LOD-ANA-PL , Planning , Problem