Symptom
- The data action copies only datasets where the segment member is part of the hierarchy.
- Using the setting CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY, specifically due to the presence of a dataset with "Segment" = #, will not work as expected.
- Error message is displayed in the advanced formulas: "Member not found".
Environment
- SAP ANALYTICS CLOUD
Reproducing the Issue
- Set a tracepoint within the advanced formula step "Copy Data";
- Run the trace of the data action;
- The calculation scope shows that # was not included.
Or
- Open the Data Action
- Click on Advanced Formulas Step
- Click on Validate
- The following error message coming up: XXXX: Member YYY not found.
Notation: (XXX - Dimension | YYY - Member)
Cause
The config setting "INCLUDE_MEMBERS_NOT_IN_HIERARCHY" only works on those dimension members that are included under the "Not in Hierarchy" node in the dimension. Whether this feature is enabled or not depends on the dimension setup. Moreover, if the dimension member is in an alternative hierarchy, this feature will not work.
Resolution
From the model change the value in the dimension in the menu "Empty Hierarchy Values" to "Group and show under "Not in Hierarchy.
See Also
- About Script Formulas and Calculations in Advanced Formulas for Planning
- 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 Connection Guide
- 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
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, data action, story, table, error, include, member, hierarchy, dimension, not, found, root, values, advanced, formulas, setup
Product
SAP Analytics Cloud all versions