3620286 - Issue Regarding LAST/DATE Exception Aggregation - SAC

• The exception aggregation type for LAST/DATE does not appear to be working properly.
• Notice from the above that LAST/DATE is set for this account, However the total is displaying a SUM.

SAP Analytics Cloud 1.0

The behavior is expected by the settings.

Go to the "Model Preferences" and check the "Structure Priority", the "Measures" is used as the "Prioritize properties and calculations from", that means the calculation would follow the Measures' setting (it is default SUM in model ) although the Last exception aggregation type was set in Account.

Two methods are available to use the LAST exception aggregation:

1. Keeping the "Structure Priority" in "Measures", and set the Exception Aggregation Type Last in Measure settings.
2. Change the "Structure Priority' into "Account", then the setting of Exception Aggregation Type Last would take effects.

Model Preferences, Measures, Account, Structure Priority, calculation, model, SUM, LAST/DATE, exceptions , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem