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
- Configure a member in Account dimension with:
- Exception Aggregation Type: Average
- Exception Aggregation Dimension: Date
- Unit & Currencies: %
- 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