SAP Knowledge Base Article - Public

3014226 - Table is keeping old BW KPI calculation property in SAP Analytics Cloud (SAC) based on Live Data connection to SAP BW

Symptom

  • BW Key Figure was defined as cumulative at the beginning and SAP Analytics Cloud (SAC) table was displaying it correctly 
  • After changing the same BW Key Figure to non-Cumulative, the existing table still displays the calculation as Cumulative 
  • If creating a new Table in same story, the calculation will show calculation as expected non-Cumulative

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.14
  • Live Data connection to SAP BW

Reproducing the Issue

  1. Log on to SAC tenant and then create a new story.
  2. Add a table based on Live BW model which includes one Key Figure defined as Cumulated in BW query.
  3. Chang the Key Figure to non-Cumulative (Cumulated = off) in BW query.
  4. Refresh the story in SAC.
    => The existing table created in step 2 still displays the calculation as Cumulative.
  5. Add a new table in same story or change data source to same model in existing table.
    => The calculation will show calculation as expected non-Cumulative

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

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, Cumulative, Cumulated, Cumulation, calculation, key figure, measure, live, bw , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0