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

BRAIN570 - Overview

• 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