SAP Knowledge Base Article - Public

3214286 - Calculations with "None" aggregation set in the model are aggregated in SAP Analytics Cloud

Symptom

Values get aggregated (e.g. year level) even if "none" aggregation is defined for the calculation on the model level.

Environment

SAP Analytics Cloud 2022



Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Create a model that has an Account dimension.
  3. Define a calculation in measures with "none" aggregation.
  4. Create a Story and add a table based off the above model.
  5. Add a dimension (e.g. year) and the calculation with "none" aggregation to the table.
  6. Notice that the calculation is aggregated for the dimension (e.g Year or Quarter level) except of not showing the number.

Cause

The model is set to prioritize calculations based on the account dimension.

Resolution

  1. Open the affected model.
  2. Go to Preferences >> Structure Properties
  3. Change "Prioritize properties and calculations from" from the Account dimension to Measures.

Keywords

SAC; aggregationNone; aggregation; percentage;  , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-ML , SAC Modelling , Problem

Product

SAP Analytics Cloud 1.0