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

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker