How To Fix BRAIN_DEV141 - Formule &1 (avec variable &2) ne peut pas être calculée avant agrégation

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN_DEV - BRAIN messages (for use by development)

• Message number: 141

• Message text: Formule &1 (avec variable &2) ne peut pas être calculée avant agrégation

Quelle est la cause de ce problème?

The formula or calculated key figure "&V1&" contains the variable "&V2&"
and at least one non-cumulative key figure.
The variable "&V2&" is a variable with replacement path from a
characteristic attribute that is replaced before aggregation. In general
the order of calculation here is the following:
generic aggregation of non-cumulative key figure
exception aggregation of non-cumulative key figure
lookup of replacement path variable value and formula calculation
exception aggregation via the replacement path characteristic (Note
1385580 describes which aggregation is used here).
According to the settings of the variable "&V1&", the formula "&V1&"
should be calculated before the non-cumulative exception aggregation.
This is only possible if the formula is a commutative formula, that
means it can be calculated before or after aggregation Summation[SUM]
with the same result, and if there is no aggregation via the replacement
path characteristic explicitly defined in the formula.
But the formula "&V1&" is not a commutative formula. Therefore it is not
possible to calculate the formula before the non-cumulative exception
aggregation

Réponse du système

An implicit exception aggregation via the replacement path
characteristic is applied according to Note 1385580 and the formula is
calculated after non-cumulative exception aggregation.

Comment corriger cette erreur?

Ensure that the flag "Calculation of Commutative Formulas After
Aggregation" is not set to true in the query properties and the switch
(see Notes 2094114 and 1668991) FAGGR_BEFORE is not set to false. If the
formula is still calculated after aggregation, then the formula needs to
be remodeled.

Procédure pour les administrateurs système

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Extrait du message d'erreur du système SAP. Copyright SAP SE.