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

• 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

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

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

This issue is currently under investigation by development.

This issue is currently under investigation by development.

• 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 > Learning > Data Connections
• 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.

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