How To Fix RSB4HANA114 - Some queries might behave differently in BW/4 HANA (formula calculation)

SAP Error Message - Details

• Message type: E = Error

• Message class: RSB4HANA - B4HANA

• Message number: 114

• Message text: Some queries might behave differently in BW/4 HANA (formula calculation)

What causes this issue?

You have set the 'RSROA_CL_FORM_SWITCH' switch to 'ON'. (For further
information about 'Switch', see SAP Note 2094114.)

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

System Response

In BW Release 7.50 SP04<(>,<)> the default behavior of 0 * N MIXED = 0
MIXED has been introduced in formula calculation. Prior to SP04<(>,<)>
the result was 0 * N MIXED = 0.
If the 'RSROA_CL_FORM_SWITCH' switch is set to 'ON'<(>,<)> the old
behavior is re-enabled.
For further information, see SAP Note 2470572.

How to fix this error?

BW/4 HANA does not support this switch.
In case you have been using the switch because you implemented a
conditional formula calculation (
using the

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 RSB4HANA114 - Some queries might behave differently in BW/4 HANA (formula calculation) ?

  The SAP error message RSB4HANA114 indicates that some queries in SAP BW/4HANA might behave differently due to the way formula calculations are handled in the new environment. This message typically arises when transitioning from older versions of SAP BW to BW/4HANA, where certain functionalities and behaviors have changed.
  Cause:
  
  Formula Calculation Changes: In BW/4HANA, the handling of formula calculations has been optimized for performance and efficiency. However, this can lead to differences in how results are computed compared to previous versions of BW.
  Data Model Differences: The underlying data model in BW/4HANA is different from earlier versions, which can affect how queries are executed and how results are aggregated.
  Query Design: Queries designed in older versions may not fully leverage the capabilities of BW/4HANA, leading to unexpected results or performance issues.
  
  Solution:
  
  Review Query Design: Analyze the queries that are generating this error. Check the formulas and calculations used in the queries to ensure they are compatible with BW/4HANA.
  Test Queries: Run tests on the affected queries to identify specific areas where results differ. This can help pinpoint the exact formulas or calculations that need adjustment.
  Adjust Formulas: Modify the formulas in the queries to align with the new calculation logic in BW/4HANA. This may involve rewriting certain calculations or using new functions that are optimized for the HANA database.
  Use BW/4HANA Features: Take advantage of new features and functionalities in BW/4HANA that may provide better performance or more accurate results.
  Consult Documentation: Refer to SAP's official documentation and release notes for BW/4HANA to understand the changes in formula calculations and how to adapt your queries accordingly.
  Engage SAP Support: If the issue persists or if you need further assistance, consider reaching out to SAP support for guidance on specific queries and their behavior in BW/4HANA.
  
  Related Information:
  
  SAP BW/4HANA Documentation: Review the official SAP BW/4HANA documentation for detailed information on changes in query processing and formula calculations.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can share their solutions.
  Training and Resources: Consider training sessions or resources that focus on BW/4HANA to better understand the new features and best practices for query design.
  
  By addressing the differences in formula calculations and adapting your queries accordingly, you can resolve the RSB4HANA114 error and ensure that your queries perform as expected in the BW/4HANA environment.