SAP Knowledge Base Article - Preview

3206624 - BW: External SAP Hana View and Query Performance

Symptom

  • You have generated an External SAP Hana View e.g. based on an BW object like a HCPR or Advanced ADSO and face a performance issue when accessing this view with SQL.
  • A External SAP Hana View is used in a Hana calculation view which is a part-provider of an CompositeProvider(HCPR). The performance of a BW query based on this HCPR is bad due to a long running Hana statement accessing the Hana calculation view.


Read more...

Environment

  • SAP BW/4HANA SAP BW/4HANA 1.0
  • SAP BW/4HANA 2.0
  • SAP NetWeaver SAP NetWeaver 7.5

Keywords

External SAP Hana View, Performance, long runtime, hmod , KBA , BW-WHM-MTD-HMOD , HANA Model Generation in BW , BW4-ME-HMOD , HANA Model Generation , 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.