How To Fix BRAIN113 - Some key figures have exception aggregation. Figures are bracketed [ ]

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN -

• Message number: 113

• Message text: Some key figures have exception aggregation. 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 exception aggregation was used during
calculation; 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 BRAIN113 - Some key figures have exception aggregation. Figures are bracketed [ ] ?

  The SAP error message BRAIN113 indicates that there are key figures in your query that have exception aggregation settings applied to them. This means that the key figures are not being aggregated in the standard way, and instead, they are subject to specific rules for aggregation based on the data context. The figures that are affected are typically shown in brackets [ ] in the error message.
  Cause:
  
  Exception Aggregation: The key figures in question are defined with exception aggregation in the InfoProvider. This means that they are aggregated based on specific conditions or exceptions rather than standard summation or averaging.
  Query Design: The query might be designed in a way that conflicts with the exception aggregation settings of the key figures.
  Data Context: The data context in which the query is being executed may not support the exception aggregation for the key figures involved.
  
  Solution:
  
  Review Key Figures: Check the definition of the key figures in the InfoProvider. Ensure that the exception aggregation settings are appropriate for your query.
  Adjust Query Design: Modify the query to either remove the key figures with exception aggregation or adjust the context in which they are being used. This may involve changing the filters, characteristics, or other settings in the query.
  Use Aggregation Functions: If you need to aggregate the data in a specific way, consider using aggregation functions that are compatible with the exception aggregation settings.
  Consult Documentation: Refer to SAP documentation or help resources for more details on how exception aggregation works and how to handle it in queries.
  
  Related Information:
  
  Exception Aggregation: This is a feature in SAP BW that allows for more complex aggregation rules based on specific conditions. It is often used for key figures that require special handling, such as calculating averages only for certain subsets of data.
  SAP BW Query Designer: Use the Query Designer tool to analyze and modify the query. You can check the properties of the key figures and see how they are set up for aggregation.
  SAP Notes and Community: Check SAP Notes for any known issues or updates related to this error message. The SAP Community forums can also be a valuable resource for troubleshooting and finding solutions from other users who have encountered similar issues.
  
  By following these steps, you should be able to resolve the BRAIN113 error and successfully run your query.