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