SAP Knowledge Base Article - Public

3103625 - Inconsistency with Exception of aggregation with formula% GRANDTOTAL in SAC


When a multiplication or division is used, the total result is required to be the sum of the detail, an Aggregation Exception with Aggregation Exception is applied for the dimensions.

When performing this parameterization and correctly save the change in the model but the data is not displayed in the history.

The replicated behavior is similar to quantity * price. only one of the parameters uses the% Grand Total.


  • SAP Analytics Cloud 2021.14.15

Reproducing the Issue

  1. Create an account formulated in the Data Model using the formula% GrandTotal.
  2. The image shows the value in the totals, but for the ratio you want to see is the sum of the results of the detail, in the image you can see the one shown by the platform.
  3. The image shows in the last row the value that you would expect to see in the totals for that measure which using GrandTotal.
  4. By following , create Exceptional Aggregation and Exceptional Aggregation  Dimensions and it saves the change correctly in the model and does not get error or warning.
  5. When opening the story No warning is displayed, but the value disappears.


This issue is currently under investigation of development team.


This issue is currently under investigation of development team.

See Also

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


Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,calculation, account, restricted, measure, dimension, operation, aggregation , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0