How To Fix BRAIN112 - Constant selection is activated. Figures are bracketed [ ]

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN -

• Message number: 112

• Message text: Constant selection is activated. Figures are bracketed [ ]

What causes this issue?

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

System Response

When a user starts a query or bookmark using Execute and Debug in the
query monitor (transaction RSRT, RSRT1, or RSRT2), the system adds
brackets to all numbers for which constant selection is active; it also
displays these numbers in a different color.
This helps you to analyze complex figures and, where applicable, to
recognize that an error has not occurred in the analytic engine.

How to fix this error?

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 BRAIN112 - Constant selection is activated. Figures are bracketed [ ] ?

  The SAP error message BRAIN112, which states "Constant selection is activated. Figures are bracketed [ ]", typically occurs in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence) when you are trying to execute a query or report that has constant selection activated.
  Cause:
  The error indicates that the query is set up to use constant selection for certain characteristics or key figures. When constant selection is activated, it means that the values for those characteristics or key figures are fixed and cannot be changed during the execution of the query. The figures being bracketed [ ] signify that they are being treated as constants, and any attempt to modify them will lead to this error.
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check Query Design:
  
  Open the query in the Query Designer.
  Look for any characteristics or key figures that have constant selection activated.
  If you need to change the values, you may need to remove the constant selection for those fields.
  
  
  
  Modify the Query:
  
  If you have the necessary permissions, you can modify the query to allow for variable selection instead of constant selection.
  Save the changes and re-execute the query.
  
  
  
  User Input:
  
  If the query is designed to use constant values for specific users or roles, ensure that you are using the correct user credentials that have the appropriate access rights.
  
  
  
  Consult Documentation:
  
  Review the documentation for the specific query or report to understand the intended use of constant selection and whether it can be modified.
  
  
  
  Contact Support:
  
  If you are unable to resolve the issue, consider reaching out to your SAP support team or consulting the SAP community for further assistance.
  
  
  
  Related Information:
  
  SAP BW/BI Documentation: Familiarize yourself with the concepts of query design, constant selection, and variable selection in SAP BW/BI.
  User Roles and Authorizations: Ensure that your user role has the necessary permissions to modify queries and access the data.
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  
  By following these steps, you should be able to address the BRAIN112 error and successfully execute your query.