"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 ?

[Savio_Dmello]

Either your Query has some complex CKF or RKF which are behaving differentlly or the HANA calc view logic is complex.

Check if the record count is getting truncated in runtime. There is a parameter which controls the count when the analyzer run complex execution plan. I am taking about backend record count not frontend excel record count.

In RSRT, execute the query with different settings for "Operations in HANA/BWA" and compare the results.
Option 1: Run with no optimized operations (everything in BW).
Option 2: Run with optimized operations in HANA and see where the result starts to deviate.
Use the debugging mode to trace the exact points where calculations or operations differ between BW and HANA.

[300221]

this is the simple straight BW query design, no CKF/RKF, all logic is in SAP HV. no matter what operations use, even though their execution plan can be different, but the final result shouldn't be different, otherwise who can trust this product. as per the debugging mode mentioned, can you please provide detail?

[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)