SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Search Topics
Topic Index
SAP HANA Modeling
Spatial Processing
Predictive Analysis

Understanding SAP HANA Engine

SAP HANA Engine:

SAP HANA has mainly 3 types of engines that are used based on the views required by the model.

Join Engine:
    • Used when querying an Attribute View
    • The join engine is also used, when you run plain SQL.

OLAP Engine:
    • Used for Analytic view (without calculated columns).

Calculation Engine:
    • Used for Analytic views with calculated attributes and Calculation views

Note: To check what engine is used to process a query: simply run the Plan Visualization on your query.

Q1: What If I execute a standard ANSI92 SQL statement from a BI tool or in SAP HANA Studio. What engines will be used?
Ans: Depends on what objects you reference in your query. If you're just querying plain base tables then the join engine will be used. As soon as you reference an analytic or calculation view, the other engines will be employed as well.

Q2: If my Analytic View foundation is joined to attribute views, is both the OLAP and JOIN Engine used?
Ans: Nope - during activation of the analytic views, the joins in the attribute views get 'flattened' and included in the analytic view run time object. Only the OLAP engine will be used then.

Support us by sharing this article.

Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 :, All rights reserved.  Privacy Policy