SAP Knowledge Base Article - Public

2599435 - Totals are not calculated correctly in a hierarchy when drilling down on a table or chart in SAP Analytics Cloud

Symptom

  • Totals are not calculated correctly in a hierarchy when drilling down on a table or chart in SAP Analytics Cloud (SAC).
  • E.g.. Q1 will be displayed as 18,900.00 where January, February and March have values of 2,100.00 respectively.
  • The expected Q1 total should be calculated as 2,100.00 x 3 = 6,300.00

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Log in to SAP Analytics Cloud.
  2. Create a table with totals.
  3. Select some measures and a date dimension.
  4. On the date dimension, select Drill - Level 3.

Cause

Exception aggregation set in the hierarchy was wrong.

Resolution

See Aggregation in Formulas and Applying Aggregation in SAP Analytics Cloud.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, total, aggregation, calculation, measure, date, time, exception, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0