How To Fix BRAIN_DEV194 - Conditions calculated in SAP HANA and exception aggregation CNT/CN0

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 194

• Message text: Conditions calculated in SAP HANA and exception aggregation CNT/CN0

What causes this issue?

Diagnosis
A query contains a key figure or a formula K1 with exception aggregation
Counter (all values) [CNT] or Counter (values unequal to zero) [CN0].
For a certain characteristic value combination no value is booked for
K1. The characteristic value combination is shown in the query result
set only because a booking for another structure element exists or
because unposted values are displayed in the query result set.
For K1 an artificial value 0 is drawn in the query result set or used as
operand in a formula F2 that has no exception aggregation.
A condition exists on K1 or on F2.
The value 0 meets the condition.
System Response
The condition result differs if conditions are calculated in SAP HANA as
the artificial 0 values are not known by the condition processing in SAP
HANA.
In case of a threshold value condition the condition result set may be
smaller because the characteristic value combinations with artificial 0
values are missing in the condition result set.
In case of a ranking list condition the condition result set may be
different as characteristic value combinations with a real value instead
of characteristic value combination with an artificial 0 value are part
of the condition result set.
Example
Let's assume a query has the following result:
Year,,Amount,,Amount in DE,,Amount in DE, CNT on Product
2015,,100,,50,,2
2016,,200,,20,,1
2017,,150,, ,,0

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

Now let's apply the condition "Amount in DE, CNT on Product" <= 1
If conditions aren't calculated in SAP HANA the query result is the
following:
Year,,Amount,,Amount in DE,,Amount in DE, CNT on Product
2016,,200,,20,,1
2017,,150,, ,,0
If conditions are calculated in SAP HANA the query result is different,
because the condition processing in SAP HANA doesn't know the artificial
0 of 2017:
Year,,Amount,,Amount in DE,,Amount in DE, CNT on Product
2016,,200,,20,,1
If the structure element "Amount" is not selected in the query, the
query result is the same with and without condition processing in SAP
HANA:
Year,,Amount in DE,,Amount in DE, CNT on Product
2016,,20,,1
Procedure
To avoid the artificial 0 values and to get the same condition result
set with and without condition processing in SAP HANA you can use
instead of exception aggregation
oCounter (all values) [CNT]: exception aggregation Summation [SUM] on
the constant 1 with the same filter as the operand of exception
aggregation Counter (all values) [CNT]
oCounter (values unequal to zero) [CN0]: exception aggregation Summation
[SUM] of a formula that uses the operator Counter [COUNT] and the
operand of the exception aggregation Counter (values unequal to zero)
[CN0] as operand
Example
Let's assume a query has the following result:
Year,,Amount,,Amount in DE,,1 in DE, SUM on Product
2015,,100,,50,,2
2016,,200,,20,,1
2017,,150,,,,
Now let's apply the condition "1 in DE, SUM on Product" <= 1
The query result set is the same with and without condition processing
in SAP HANA:
Year,,Amount,,Amount in DE,,1 in DE, CNT on Product
2016,,200,,20,,1

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.