Question Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti... in Technology Q&A

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

300221 — Sat, 14 Sep 2024 01:53:44 GMT

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 ?

Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti...

nachtaktiv — Sat, 14 Sep 2024 02:22:54 GMT

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.

Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti...

300221 — Sat, 14 Sep 2024 10:57:23 GMT

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.

Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti...

300221 — Sat, 14 Sep 2024 11:01:24 GMT

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)

Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti...

Savio_Dmello — Sat, 14 Sep 2024 18:26:04 GMT

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.

Re: "Operations in SAP HANA/BWA" in tab "Runtime Properti...

300221 — Sun, 15 Sep 2024 02:58:44 GMT

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?