SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.11

Reproducing the Issue

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.

Cause

This is currently a limitation with SAP Analytics Cloud.

Resolution

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

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

Product

SAP Analytics Cloud 1.0