SAP Knowledge Base Article - Public

3152711 - All calculations based on a measure using local calculation feature in BW cannot work in SAP Analytics Cloud(SAC)

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

  1. Create a calculation based on such measure from a BW Live model.
  2. 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

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

SAP Analytics Cloud 1.0

Attachments

Pasted image.png