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  - 

  1. Join Engine
  2.  OLAP Engine 
  3. 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 - 


 

23 comments:

  1. 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

    ReplyDelete
    Replies
    1. Thank you & We are happy to provide good information to you.

      Delete
  2. 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

    ReplyDelete
    Replies
    1. Thank you & We will share more blog on various SAP topics in the near future.

      Delete
  3. 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

    ReplyDelete
  4. 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.

    ReplyDelete
  5. 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

    ReplyDelete
  6. 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.

    ReplyDelete

  7. After a long time, I read a very beautiful and very important article that I enjoyed reading. I have found that this article has many important points, I sincerely thank the admin of this website for sharing it. Boat Motors for Sale

    ReplyDelete
  8. You've provided quite good information here. This is fantastic since it expands our knowledge and is also beneficial to us. Thank you for sharing this piece of writing. Rent Bidwell 3600 Paver machine in USA.

    ReplyDelete
  9. It is what I was searching for is really informative. Forklift Engine Parts UAE It is a significant and useful article for us. Thankful to you for sharing an article like this.

    ReplyDelete
  10. Great post, your all points fully clarify, Buy Used Engines Parts Online in California These steps are very helpful for us. Thank you for providing such valuable information.

    ReplyDelete
  11. Very well written article. It was an awesome article to read. Complete rich content and fully informative. I totally Loved it.Truck Spare Parts in Bhopal Madhya Pradesh

    ReplyDelete
  12. Your post is very informative for me. excellent article about , I really like this post, and thanks for sharing.

    ReplyDelete
  13. Your post is very informative for me. excellent article about HELI forklift parts dealer , I really like this post, and thanks for sharing.

    ReplyDelete
  14. This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post.! Xlr Boost.

    ReplyDelete
  15. Extremely useful information which you have shared here about Yamaha Complete Lower Units This is a great way to enhance knowledge for us, and also beneficial for us. Thank you for sharing a blog like this.

    ReplyDelete
  16. Good blog i have read full blog . I think you should write blog on Trade-In Forklift

    ReplyDelete
  17. Indeed, even a non-toy, like the mother's caring look and grinning face, are recreational to the baby.
    high performance fuel injectors

    ReplyDelete
  18. Indeed, even a non-toy, like the mother's caring look and grinning face, are recreational to the baby.
    www.snakeeaterperformance.com

    ReplyDelete
  19. Studies have demonstrated that one of the main social advantages of recreation is the weaving together of humankind in bunch exercises.
    https://www.snakeeaterperformance.com/

    ReplyDelete