Symptom
Within one story, containing two reports sharing identical filters, calculated accounts, and restricted measures, when the user introduces a dimension (Entity) from the restricted measures to the columns and display totals, the total reported with the entity differs from the total reported without the entity.
Environment
SAP ANALYTICS CLOUD
Reproducing the Issue
- Create reports sharing identical filters, calculated accounts, and restricted measures.
- Add dimension (Entity) from the restricted measures to the columns
- Display totals which will be displayed incorrectly.
Cause
This is the standard behavior.
Resolution
In mathematics, with infinite calculation precision, the outcome of a calculation remains independent of the calculation process's path.
However, when computers perform the same calculations, the result can vary depending on the processing path.
An explanation (to some extent) for 'Totals' calculations can be found in SAP Note 2850354, using a different example.
See Also
- 2850354 - "Show Totals" on a calculated measure doesn't return the sum up of all the members of this measure in SAP Analytics Cloud (SAC)
- 1515837 - How To: Enhancement Request Process using the Customer Influence and Adopt site
- 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, restricted measure, calculation, calculated account, totals , KBA , LOD-ANA-TAB , Table , Problem