How To Fix BRAIN_DEV649 - Formula &1 &2 contains discontinued feature formula before aggregation

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 649

• Message text: Formula &1 &2 contains discontinued feature formula before aggregation

What causes this issue?

The formula contains the discontinued feature calculation before
aggregation.

System Response

Query generation is aborted.

How to fix this error?

Change the relevant formula.
If the calculation operation commutates with the aggregation, the flag
"calculation after aggregation" can be set. Examples of calculations
that commutate with aggregation:
<EX>keyfigure_1 + key_figure_2 with aggregation SUM</>
<AB>keyfigure_1 - key_figure_2 with aggregation SUM</>
<AB>keyfigure * const with aggregation SUM</>
<AB>keyfigure / const with aggregation SUM</>

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

If the operation has to be calculated on a certain granularity, use
formula exception aggregation to specify the granularity on which the
formula is calculated. The granularity can be specified in two different
ways:
Either you can specify which characteristics remain in groupby when the
formula is calculated (this is the normal formula exception
aggregation), or you specify which characteristics are used for standard
aggregation of the data before formula exception aggregation takes
place. This second option is new and should be used with extreme
caution. This is because huge intermediate results can be easily created
and the database result set can also reach a very large size.
Rethinking the order of calculation and aggregation can significantly
speed up processing.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message BRAIN_DEV649 - Formula &1 &2 contains discontinued feature formula before aggregation ?

  The SAP error message BRAIN_DEV649 indicates that a formula in a query or calculation view is using a feature that has been deprecated or discontinued before the aggregation step. This typically occurs in SAP BW (Business Warehouse) or SAP BW/4HANA environments when working with queries in the BEx Query Designer or similar tools.
  
  Cause:
  The error arises when:
  
  A formula or calculation is using a feature that is no longer supported in the current version of SAP BW or BW/4HANA.
  The formula may include operations or functions that were valid in earlier versions but have been removed or replaced in the current version.
  The formula is being executed in a context where it cannot be processed due to the aggregation rules or the data model.
  
  
  Solution:
  To resolve the BRAIN_DEV649 error, you can take the following steps:
  
  
  Review the Formula: Check the formula mentioned in the error message. Identify any functions or features that are marked as deprecated