Course Content
Information Views
- Connect Tables
- Create Dimension and Cube Calculation Views
Modeling Functions
- Create Hierarchies
- Create Calculated and Restricted Columns
- Filter Data
- Use Variables and Input Parameters
- Implement Currency Conversion
- Create Decision Tables
SQL Script and Procedures
- Introduce SQL and SQLScript
- Create Table Functions and Procedures
- Use the SQL Debug Tools
Virtual Data Models in SAP HANA
- Use SAP HANA Live
- Overview of Virtual Data Models built with Core Data Services (CDS)
- Text, Spatial, Predictive and Graph Modeling
Management and administration of Models
- Validate Information Models
- Transport Information Models
- Rename, copy move models
- Define schema mapping
- Convert Deprecated Modeling artifacts using migration tools
Security in SAP HANA Modeling
- Understand the Key Concepts of SAP HANA Security
- Define Data Access Security
Optimization of Models
- Apply Best Practices to Model Design
- Introduction to Plan Visualizer and Explain Plan tools