How To Fix BRAIN575 - BWA/SAP HANA will be used despite virtual characteristics/key figures

BRAIN575 - Overview

• Message type: E = Error

• Message class: BRAIN -

• Message number: 575

• Message text: BWA/SAP HANA will be used despite virtual characteristics/key figures

What causes this issue?

The query uses virtual characteristics or virtual key figures filled in
a BADI implementation. Optimized operations in BWA/HANA are switched on
at the same time. This influences the granularity of the database result
set as well as the format.
The BADI implementation must stick to the following rules to guarantee a
reliable and reproducible query result set:
It must be interchangeable with aggregation, as described in
<DS:NA.BRAIN_DEV152>this section.</>
It must only process the result set row by row, and not draw any
conclusions between multiple rows of the result set. In particular, no
totals can be calculated in the BADI implementation.

System Response

BWA/HANA is used despite virtual characteristics and key figures at
least up to "Optimized Access". More details can be found
<DS:DE.RSRTREXOPS>here.</>

How to fix this error?

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 deactivate use of advanced operations in BWA/HANA for the
queries that use virtual key figures.
You can use formulas with exception aggregation instead of virtual key
figures.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message BRAIN575 - BWA/SAP HANA will be used despite virtual characteristics/key figures ?

  The SAP error message BRAIN575 indicates that there is a conflict between the use of virtual characteristics or key figures and the configuration of the SAP HANA or BW Accelerator (BWA) environment. This message typically arises when you are trying to execute a query that includes virtual characteristics or key figures, but the system is set to use BWA or SAP HANA for processing, which does not support these virtual elements.
  
  Cause:
  
  Virtual Characteristics/Key Figures: The query you are trying to execute includes virtual characteristics or key figures. These are not physically stored in the database but are calculated on-the-fly during query execution.
  BWA/SAP HANA Configuration: The system is configured to use BWA or SAP HANA for query processing, which does not support the use of virtual characteristics or key figures in the same way as traditional BW queries.
  
  
  Solution:
  To resolve this issue, you can consider the following approaches:
  
  
  Modify the Query:
  
  Remove the virtual characteristics