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-WHM-DBA-COPR , CompositeProvider (local version) , BW-BEX-OT-HCPR , CompositeProvider Query , How To

About this page

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

Search for additional results

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