SAP Knowledge Base Article - Preview

2176246 - OLAP Functions cannot be Pushed Down to HANA when using HCPR Built on Calculation Views


  • You build a HCPR (HANA Composite Provider) as union of calculation views.
  • You define a query on this HCPR and create a formula using exception aggregation on a key figure. (For example, exception aggregation count over a characteristic. Or using other OLAP functions that can be pushed down to HANA according to Note 2063449.)
  • In the query property you have choose 'Operations in HANA' (TREXOPS) as 6.
  • However the function is still executed in ABAP, not downported to HANA

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.



BW 740


SAP NetWeaver 7.4


KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-HCPR , CompositeProvider Query , BW-WHM-DBA-COPR , CompositeProvider (local version) , 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.