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.

AnswerBot

• 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 in the SAP documentation.
  
  
  Update the Formula: Modify the formula to remove or replace the deprecated features. You may need to use alternative functions or approaches that are supported in the current version.
  
  
  Check Aggregation Context: Ensure that the formula is appropriate for the aggregation context in which it is being used. Some calculations may need to be adjusted based on how data is aggregated.
  
  
  Consult Documentation: Refer to the SAP Help Portal or release notes for your specific version of SAP BW/BW4HANA to understand which features have been deprecated and what alternatives are available.
  
  
  Test the Changes: After making the necessary adjustments, test the query or calculation view to ensure that it executes without errors.
  
  
  Seek Help from SAP Community: If you are unable to resolve the issue, consider reaching out to the SAP Community or support forums for assistance. Provide details about the formula and the context in which the error occurs.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide guidance on deprecated features.
  SAP BW Documentation: Review the official SAP BW documentation for information on supported functions and best practices for creating formulas.
  Version-Specific Changes: Be aware of changes between different versions of SAP BW/BW4HANA, as features may be added or removed in newer releases.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.