SAP OSS Note 2021443 version 0003 contains details of a know issue related to Non-cumulatives: Incorrect results for complex filter condit
. This includes any associated symptoms and instructions on how to fix it, see below for full details. Also check out the comments section to view/add related contributions, questions or screen shots, based on real life experience of this oss note and problem.
...For more information about the SAP support system known as OSS please check out the SAP OSS NOTES SECTION, whih includes how to download & implement them onto your SAP system using transaction code SNOTE.
When you start a non-cumulative query, the system displays too little
data, incorrect data, or blank lines.
If you use an SAP HANA database, the execution of the query delivers
different results if you execute it in SQL mode and TREXOPS (mode
0 = "No optimized operations in HANA/BWA") or in extended aggregate
mode (mode > 0).
The problem occurs in all databases.
Even if no aggregates exist, the results may be correct when you run in
RSRT - "Execute&Debug" - "Do not use aggregates".
This error occurs only if there are a lot of filter conditions with
different field element selections (FEMSs) in the query (for examp
le, restricted key figures). This error only occurs in case of an SQL
execution.
,,SAP BW 7.40
,,Import Support Package 8 for SAP BW 7.40 (SAPKW74008) into your BW
system. The Support Package is available when SAP Note 2000326,, "S
AP BW News NW BW 7.4/ABAP SP08", which describes this Support Package in
more detail, is released for customers.
In urgent cases, you can implement the correction instructions as an
advance correction.
You must first read SAP Note 1668882, which provides information about
transaction SNOTE.
To provide information in advance, the SAP Notes mentioned above may
already be available before the Support Package is released. In t
his case, the short text of the SAP Note contains the words "Preliminary
version".
Non-cumulative, non-cumulatives, query, incorrect data, TREXOPS, blank,
complex hull