SAP Learning Academy: The different types of engines available in SAP HANA

Content of this topic -

👉What are the available runtime engine of SAP HANA.

👉Explanation of each and every engine types.

👉SAP HANA Calculation Views Enhanced for Master Data and OLAP Data Models.

Available engine type of SAP HANA -

Join Engine
OLAP Engine
Calculation Engine

Join Engine

1. This engine is used when you execute any attribute view in SAP HANA, or when you run native SQL on more than one table with a join condition. This means that all kind of joins can be processed here. If there are any calculations involved either in the attribute view or in native SQL, then the join engine also uses the calculation engine for these calculations and to collect the results.

2. Attribute Views or join condition with out calculation involved uses the Join Engine.

OLAP Engine

1. The online analytical processing (OLAP) engine is used in the back end whenever you run any queries on analytic views in SAP HANA. It is used for calculation and aggregation based on a star schema. If any calculations need to be performed, then the calculation engine is used along with the OLAP engine.

2. Analytic Views (without derived columns) use the OLAP Engine

3. If there are no additional calculations performed like calculated columns, restricted measures and counters, then everything will be processed in OLAP Engine.

4. OLAP Engine acts as join engine for those Attribute Views used in Analytic Views, without any calculated columns.

Calculation Engine

1. This is used along with the OLAP engine or join engine for complex calculations that cannot be processed by the other engines alone.

2. Calculation Views or Analytic Views with derived columns use this engine.

........................................

SAP HANA Calculation Views Enhanced for Master Data and OLAP Data Models

Experience has proved that the data transfer between the different SAP HANA engines can result in bottlenecks. This can cause performance disadvantages. For this reason, starting from version SPS9, SAP has enhanced the scope of SAP HANA calculation views so that it can take over the role of the OLAP engine and join engine.

👉You can watch the below video for this explanation -

24 comments:

imlanguagesJune 26, 2021 at 10:35 PM
I read your post and this blog is very good. You have provided good knowledge in this blog.This blog really impressed me. Thank you for sharing your knowledge with all of us. Used Engines for Sale
Laura BushJune 29, 2021 at 1:52 PM
This is excellent information which is shared by you. This information is meaningful and magnificent for us to increase our knowledge about it. Keep sharing this kind of information. Thank you. Manuales SAP HANA
TracksNTeethJuly 16, 2021 at 10:48 PM
The content you've posted here is fantastic because it provides some excellent information that will be quite beneficial to me. Thank you for sharing that. Keep up the good work. Final Drives for Excavators
tradeimexinfoJuly 30, 2021 at 10:00 PM
During this post, you have shared fantastic content about import export data provider. This article provided me with some useful knowledge. Thank you for sharing that. Keep up the good work.
Jimmy CarterAugust 23, 2021 at 10:00 PM
You have worked nicely with your insights. Lots of valuable data can be taken from your article. Genuinely it is a significant article for us. SAP HANA handbooks ebooks
aaronnssdSeptember 22, 2021 at 1:54 AM
The information you've provided is useful because it provides a wealth of knowledge that will be highly beneficial to me. Thank you for sharing Manuales SAP pdf. Keep up the good work.