HA300 - SAP HANA Modeling

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