2960958 - Not possible to accumulate or keep a running total calculation of a measure with year by year granularity in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Accumulated values do not show the correct values in chart visualisations or reset to the default measure at the start of the new year.

• SAP Analytics Cloud (Enterprise) 2020.14.11

Option 1)

1. Create a story based on a model or data source with numerical values (measures) to build a running total of the accumulated values.
2. Create a Combination Column & Line Comparison Chart with the following structure in the builder panel:
• Column Axis - Standard Measure i.e sales
• Line Axis - Aggregated Calculation based on this Measure i.e total sales
• Dimension - Date with a drill level > 3 to showcase month by month comparison
3. Create a calculation of type aggregation sum
4. Observe that accumulated values do NOT show at all and simply represent the same values as the measures in the Column Axis

Option 2)

1. Create a story based on a model or data source with numerical values (measures) to build a running total of the accumulated values.
2. Create a Combination Column & Line Comparison Chart with the following structure in the builder panel:
• Column Axis - Standard Measure i.e sales
• Line Axis - Aggregated Calculation based on this Measure i.e total sales
• Dimension - Date with a drill level > 3 to showcase month by month comparison
3. Create a calculation of type restricted measure with the selection context the date with YTD (year to date) filters.
4. Observe that the values accumulate for each quarter (q1, q2, q3, q4) and then at the start of a new year the accumulation is reset.

This is currently a limitation with SAP Analytics Cloud.

This feature is proposed to be included in the 2021 roadmap.

• 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?
• 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, accumulation, running total, calculation, aggregation, sum , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem