How To Fix BRAIN_DEV152 - Le cache est utilisé malgré les caractéristiques/ratios virtuels.

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 152

• Message text: Le cache est utilisé malgré les caractéristiques/ratios virtuels.

Quelle est la cause de ce problème?

The query uses virtual characteristics or virtual key figures filled in
a BADI implementation. The result of this BADI implementation is stored
in the analytic engine query cache and might be reused in navigation
contexts with less characteristics in drill. This only leads to reliable
and reproducible query results if the operations performed in the BADI
implementation are interchangeable with aggregation. SAP Note 1717880
describes the problem and the possible solutions.
A simple example for a problematical BADI implementation
The BADI changes the value of a key figure with standard aggregation SUM
to 0 if it is negative. Assume the following data inside the
infoprovider:
Country,,Quantity
Germany,,-50 PC
France,,+20 PC
Netherlands,,+60 PC
If the data is read with the Country, all rows are processed by the
BADI, the quantity for Germany is changed to 0 PC, and the total
quantity is +80 PC. If the data is read pre-aggregated, only one row is
processed by the BADI, and the total quantity is +30 PC. Depending on
the granularity the result is different. Depending on the current
content of the query cache the result for the total can be different.
This is unexpected of course.

Réponse du 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.

Comment corriger cette erreur?

The following solutions are possible, depending on the type of
operations performed in the BADI implementation:
You can specify a level of detail in the user exit that is the minimum
level for the reading of the data.
You can use formulas with exception aggregation instead of virtual key
figures.
You can switch off the usage of the OLAP cache.

Procédure pour les administrateurs système

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