/
Browse
/
Courses
/
Working with Calculation Views in SAP HANA Cloud
/
SQL hierarchies
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
Quiz
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
Quiz
Performance Techniques
Health checks
Static cache
Union pruning
Join cardinality
Optimize join
Dynamic join
Downloads
Quiz
Performance Deep-Dive and Migration
Instantiation
Execution
Migration
Troubleshooting – Tips and tricks
Downloads
Quiz
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
Quiz
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
Quiz
Performance Techniques
Health checks
Static cache
Union pruning
Join cardinality
Optimize join
Dynamic join
Downloads
Quiz
Performance Deep-Dive and Migration
Instantiation
Execution
Migration
Troubleshooting – Tips and tricks
Downloads
Quiz
SQL hierarchies
Next lesson