Symptom
The following behavior occurs in SAP Analytics Cloud for Planning (SAC):
-
Disaggregation in accounts with Average Exception Aggregation setting on does not work properly.
-
Bottom-up planning works but top-down planning does not if there is already an existing value.
Environment
- SAP Analytics Cloud (Enterprise) 2022.8.7
Reproducing the Issue
- Open an SAC story that contains a planning enabled table.
- Enter data in a base level cell to do the bottom up planning.
- The aggregation works as expected.
- Enter data in a parent level cell to do the top down planning.
- The disaggregation does not generate the expected values.
Cause
The data entry on a booked average value does not mean that we just copy down this value to every single member which is below.
We keep this proportionally unless all values are zero to start with.
You can find more material about the topic here: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.11/en-US/fac0e8d372634024b7f2fb275ee98bc7.html
Resolution
The recommended way to use the top-down and the bottom-up processes would be to do the top-down process first and then do the bottom-up method.
In this way, they wouldn’t influence each other, and it would be a safer way to proceed.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- 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?
- 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
KBA , HAN-DB-EPM , SAP HANA Planning and Simulation Platform , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , Problem