How To Fix BRAIN_DEV098 - &1: "Exclude All from Reference characteristics" not allowed

BRAIN_DEV098 - Overview

• Message type: E = Error

• Message class: BRAIN_DEV - BRAIN messages (for use by development)

• Message number: 098

• Message text: &1: "Exclude All from Reference characteristics" not allowed

What causes this issue?

The formula "&V1&" has the setting "Exclude All from Reference
Characteristics". For the exception aggregation "&V2& [&V3&]" this
setting is not allowed.

System Response

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

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

BRAIN_DEV098 - Details

• The SAP error message BRAIN_DEV098, which states "Exclude All from Reference characteristics not allowed," typically occurs in the context of SAP BW (Business Warehouse) or SAP BW/4HANA when working with queries or data models that involve characteristics and key figures.
  
  Cause:
  This error usually arises when you attempt to exclude all values from a reference characteristic in a query or a data model. Reference characteristics are used to link data from different InfoProviders or to create relationships between different data elements. The system does not allow the exclusion of all values from a reference characteristic because it would lead to ambiguity in the data retrieval process.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check Query Design: Review the query design in the Query Designer. Ensure that you are not trying to exclude all values from a reference characteristic. Instead, specify at least one value or a range of values to include