How To Fix BRAIN570 - Input-ready formula &1 uses illegal exception cell &2

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN -

• Message number: 570

• Message text: Input-ready formula &1 uses illegal exception cell &2

What causes this issue?

Input-ready formula &V1& is in the key figure structure and uses cell
&V2& as an operand. Exception cell &V2& has a value that can change when
entries are made. This can occur in the following cases:
Exception cell &V2& is input-ready.
Exception cell &V2& is a formula that includes input-ready values.
Input-ready exception cells cannot be used in a formula in the key
figure structure, as there are no inverse formulas for them.
Modeling options that are permitted in terms of inverse formulas in
queries with two structures and exception cells are described in the
documentation.

System Response

The query has errors and will not be generated.

How to fix this error?

Adjust the query definition accordingly.

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 BRAIN570 - Input-ready formula &1 uses illegal exception cell &2 ?

  The SAP error message BRAIN570 indicates that there is an issue with an input-ready formula in SAP BW (Business Warehouse) or SAP BPC (Business Planning and Consolidation). Specifically, it points out that the formula is using an illegal exception cell. Here’s a breakdown of the cause, potential solutions, and related information:
  Cause:
  
  Illegal Exception Cell: The formula is trying to reference a cell that is not allowed as an exception cell. Exception cells are typically used to handle specific cases in planning or reporting, and there are rules about which cells can be used in this context.
  Formula Configuration: The formula may not be correctly configured, leading to the use of an invalid cell reference.
  Data Model Issues: There may be issues with the underlying data model or the way the input-ready query is set up.
  
  Solution:
  
  Check Formula Definition: Review the input-ready formula to ensure that all referenced cells are valid. Make sure that the exception cells used in the formula are allowed and correctly defined.
  Modify Exception Cells: If you find that the formula is using an illegal exception cell, modify the formula to use valid cells. You may need to consult the documentation or guidelines for exception cells in your specific SAP environment.
  Validate Input-Ready Query: Ensure that the input-ready query is set up correctly and that all necessary settings are configured properly.
  Test with Different Scenarios: If possible, test the formula with different scenarios or data to see if the issue persists. This can help identify if the problem is data-specific.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on exception cells and input-ready formulas.
  Seek Support: If the issue persists after checking the above points, consider reaching out to your SAP support team or consulting the SAP community for further assistance.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional context.
  SAP Community: Engage with the SAP Community forums where other users may have encountered similar issues and can share their solutions.
  Training and Documentation: Review training materials or documentation related to SAP BW/BPC to better understand how to work with input-ready formulas and exception cells.
  
  By following these steps, you should be able to identify and resolve the issue related to the BRAIN570 error message.