"Operations in SAP HANA/BWA" in tab "Runtime Properties" of BW query

[300221]

Hi Expert,

    we have a SAP AO report, running on sap bw query (source from SAP HANA view). when set [0]No optimized operations in SAP HANA/no BWA for "Operations in SAP HANA/BWA" in tab "Runtime Properties" of the BW query. the data is correct.

    However, when set operation to other values, the report result is wrong.

    My question: why report result is not consistent by setting different operation values ?

[nachtaktiv]

Query can be optimized by deleting the fields not needed in the SQL-statement.
Your source did not return the same results with and without these fields, so check the aggregation behavior first.
Maybe the "Keep" flag in HANA can help to bring all necessary fields into the final result.        

[300221]

we didn't change any objects for the report, I only change "Operations in SAP HANA/BWA" in tab "Runtime Properties" of the BW query as described above. I am not looking how to improve the performance. I am just curious why different operation setting caused different report result.

[300221]

there is not any objects' change for the report , including data source (sap hana view), BW objects (open ODS views etc), BOBJ objects (OLAP connection, report itself etc)