This course teaches you how to develop SAP HANA calculation view models in SAP HANA Cloud. It includes basic concepts of working with the SAP HANA Deployment Infrastructure and covers various performance techniques. You will learn how to work in the SAP HANA Cloud development environment, use advanced features in calculation view modeling, create efficient calculation views, leverage optimization techniques, and analyze as well as troubleshoot performance issues.
Learn Generative AI, Prompt Engineering, and LLMs for Free
Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Syllabus
- Working Environment and Basic Concepts
- Introduction to the course
- Development environment
- HDI concepts in general
- HDI concepts for tables and rights
- HDI deployment with SAP Business Application Studio
- HDI deployment – Administration aspects
- Downloads
- Assignment Week 1
- Using External Objects and Modeling Topics
- Accessing external objects – Part 1
- Accessing external objects – Part 2
- Using virtual tables
- Types of views (dimension, cube, star join)
- Input parameters and variables
- Ranking
- SQL hierarchies
- Analytic privilege
- Downloads
- Assignment Week 2
- Performance Techniques
- Health checks
- Static cache
- Union pruning
- Join cardinality
- Optimize join
- Dynamic join
- Downloads
- Assignment Week 3
- Performance Deep-Dive and Migration
- Instantiation
- Execution
- Migration
- Troubleshooting – Tips and tricks
- Downloads
- Assignment Week 4