Symptom
A Bex Condition was created in a BW query to filter data in query result, for example, Less than 1 on measure1. In the query result, measure1 has values 0, 2, and NULL(empty). After activating the Condition, only the entry with 0 is displayed.
In JAVA Web, both the entries with 0 and NULL is displayed.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Run a story on a live model based on a BW query.
- Activate the condition.
- The query result is not expected.
Cause
The behaviour of handling Bex Conditions in each front end tool has some differences, for example, in Bex Web, Analyisis for offcie and SAC.
In SAC, Bex Condition will consider NULL values as real blank, so the result of the comparison with a number will be false.
In Bex Web, NULL will be considered as 0. The are working as the respective design.
Resolution
This behaviour is by design in SAC. Please change your query design accordingly if necessary.
Keywords
NULL values, empty values, BW condition , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , Problem