Symptom
- Calculations based on measures, which use a local calculation feature in BW, cannot work.
Environment
- SAP Analytics Cloud (Enterprise) 2022.2.2
Reproducing the Issue
- Create a calculation based on such measure from a BW Live model.
- The calculation cannot return the expected value.
Cause
- E.g. this measure is a key figure with flag Calculate Single Values As: Cumulated = true in the BW query definition.
- As explained in SAP Note 1151957 (see point III), Local Calculations are only a means of superficially changing the display. In subsequent calculations the 'original values' determined by the OLAP Engine are used!
- For example, if values of the key figure in the info provider are (1,5,2,6,7) then BW/OLAP will provide only values (1,5,2,6,7) and later these values will be cumulated using list calculation so it finally shows as (1,6,8,14,21) but its real values are still (1,5,2,6,7).
- So when including this key figure in a calculation, it will use the values (1,5,2,6,7) instead of the values (1,6,8,14,21) showing in SAC.
-
For more information, please refer SAP Note 2010790 - Cumulative Value Display and the examples in the below wiki link:
https://wiki.scn.sap.com/wiki/display/BI/Cumulative+Value+Display
Resolution
As explained above, the results of the calculations based on key figures checked with cumulated might be unexpected but correct. So it is necessary to review the calculations and the underlying key figures referring SAP Note 1151957 and 2010790 for further confirmation.
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-DES , Story Design & Visualizations , BW-BEX-OT-BICS-INA , BW INA provider , Problem
Product
Attachments
Pasted image.png |