SAP Knowledge Base Article - Preview

2365030 - BW Query slower with HANA pushdown (Operations in HANA)

Symptom

When a BW query is executed with HANA pushdown (TREXOPS=6 or TREXOPS=7 or TREXOPS=8) it is slower than when it is executed without HANA pushdown (TREXOPS=0 or TREXOPS=2 or TREXOPS=3).


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5
  • SAP enhancement package 1 for SAP NetWeaver 7.3
  • SAP BW/4HANA

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

performance, runtime, BWonHANA, hana pushdown, exception aggregation, TREXOPS, Operations in BWA, currency conversion, UOM, unit conversion, quantity, constant selection, optimizer, defensive, offensive, DBTRANS , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-BEX-OT , OLAP Technology , BW-BEX-OT-OLAP , Analyzing Data , HAN-DB-ENG-BW , SAP HANA BW Engine , BW4-AE , Analytic Engine , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.