How To Fix BRAIN_DEV141 - Formel &1 mit Variable &2 kann nicht vor der Aggregation berechnet werden

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 141

• Message text: Formel &1 mit Variable &2 kann nicht vor der Aggregation berechnet werden

Was verursacht dieses Problem?

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

Systemantwort

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.

Wie behebe ich diesen Fehler?

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.

Vorgehensweise für Systemadministratoren

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE