FIX Operator (New)

The FIX operator is a data function that fixes the context of the aggregation.

There is a correlation between exception aggregation and constant selection: The data that flows into the exception aggregation is grouped by the reference characteristic of the exception aggregation, for example by characteristic Product. In conjunction with a constant selection, this behaviour means that the constant selection by Product is basically rendered ineffective.

If the exception aggregation and the constant selection take place using the same characteristic, it is more likely that the GROUP BY clause will be ignored during calculation of the exception aggregation. This allows execution of the constant selection before calculation of the formula. You use the FIX operator for this.