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