3503629 - Incorrect Measure Aggregation in Cross Calculation in SAP Analytics Cloud

• Measure Aggregation type 'LAST' does not work correctly when used with Cross Calculation in SAP Analytics Cloud.
• The measure shows the sum of nodes instead of the last data when cross calculation is added.

SAP Analytics Cloud

1. Create a model in SAP Analytics Cloud with a measure that has the aggregation type set to 'LAST' across the Date dimension.
2. Add this measure to a table in a story and observe that it correctly shows the last data.
3. Add a Cross Calculation to the table.
4. Observe that the measure now shows the sum of the nodes instead of the last data.

The issue arises because the SolveOrder for the Cross Calculation is set higher than that for the Measure.

According to the backend query definition in this example:

• The measure 'measure name' has a SolveOrder of 1.
• The Cross Calculation 'cross calculation name' has a SolveOrder of 10.

Due to the higher SolveOrder, the Cross Calculation overrides the Exception Aggregation of the measure.

Story cross calculations take priority over modeling calculations and this behavior is by design.

If this is a critical feature for your business, please raise an enhancement request at SAP Influence: SAP Influence.

To work around this behavior:

1. Remove the Exception Aggregation operation of the base measure in the model.
2. Create an Aggregation Calculation under Measures, selecting the base measure (e.g., FTE) with Aggregation operation set to 'Last' and Aggregation dimension set to Date.

Set Structure Priority and Create Custom Solve Order

SAP Analytics Cloud, Measure Aggregation, Cross Calculation, SolveOrder, Exception Aggregation, LAST aggregation , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-PL , Planning , LOD-ANA-AD , Analytics Designer , LOD-ANA-TAB , Table , Problem