SAP Knowledge Base Article - Public

3240239 - Exception Aggregation Type "Average" default back to Sum aggregation type when data is entered in a story

Symptom

  • An Account dimension member is set up with:
    • Exception Aggregation Type: Average
    • Exception Aggregation Dimension: Date
    • Unit & Currencies: %
  • When the data is submitted into a story on Date dimension, it defaults back to SUM. 
    • For example, when 6% is submitted for Year 2022, the value are spread 0.5% in each month of 2022. 
    • Instead, same percentage, 6%, should be flow down to each month of 2022. 

Environment

  • SAP Analytics Cloud (Enterprise) 2022.15.7

Reproducing the Issue

  1. Configure a member in Account dimension with:
    • Exception Aggregation Type: Average
    • Exception Aggregation Dimension: Date
    • Unit & Currencies: %
  2. Submit a value in a row for Date dimension. Notice the value are spread in each month as SUM, not Average. 

Cause

Structure Priority(Model Preferences) is set to Measures, which is configured with Aggregation Type: SUM. 

Resolution

Change Structure Priority(Model Preferences) from Measures to Account. 

Keywords

aggregate, disaggregate, percentage, sum, average, measure, account , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0