Monday, April 7, 2014

BW on HANA , how it speeds up things?

The BW OLAP engine has now become the OLAP Compiler for HANA, also known as the Analytic Manager, pushing down further OLAP operations down to HANA provides offering unrivaled query performance. Additional business insights can be achieved by overcoming existing ABAP based limits. A summary of the OLAP features pushed down into the HANA database is summarized below:

OLAP Features pushed down to HANA in BW 7.3x
  • Restricted key figures
  • Exception Aggregation CNT for quantity key figures without unit conversion
  • Exception Aggregation of currency key figures with optional currency conversion

OLAP Features pushed down to HANA in BW 7.4 SP5
  • Avoid intermediate result set materialization (e.g. Exception Aggregation)

OLAP Features pushed down to HANA in BW 7.4 SP6 and beyond
  • Stock coverage Key Figure
  • Hierarchy Handling
  • Formula exception aggregation
  • Processing of further query scenarios in HANA (Joins, Union, etc.)
  • Handling of inventory Key Figures
* Pluck from http://www.agilityworks.co.uk/our-blog/sap-bw-7-4-sp5-on-hana-better-smarter-faster/

Posted by at

1 comment:

  1. UnknownDecember 12, 2014 at 2:13 AM

    This article data was thus nice. that is incredibly abundant helpful on behalf of me and affected by reading. Your data is incredibly hip to full to SAP HANA ADMIN Learners.Have a tendency to area unit providing the simplest SAP HANA ADMINISTRATION on-line coaching with full-fledged IT college.Administrators will use the SAP HANA studio, for sap hana online training

    ReplyDelete

Subscribe to: Post Comments (Atom)