- SAP Implementation & Modeling with HANA Information Views
- Introducing Information Views
- Understanding the Different Types of Views
- Working with Common View Design Features
- Using Nodes in Calculation Views
- Using Projection Nodes
- Using Join Nodes
- Working with Data Sets
- Aggregating Data
- Creating Cubes with Star Join Calculation Views
- Extracting Top Values with Rank Nodes
- Modeling Functions
- Create Restricted and Calculated Columns
- Filter Data
- Use Variables and Input Parameters
- Create Hierarchies
- Implement Currency Conversion
- Using SQL in Models
- Introducing SAP HANA SQL
- Working with SQLScript
- Query a Modeled Hierarchy Using SQLScript
- Creating and Using Functions
- Creating and Using Procedures
- CDS in SAP HANA Modeling
- Defining the Persistence Layer Using CDS
- Creating Views with CDS
- Optimization of Models
- Using Tools to Check Model Performance
- Implementing Good Modeling Practices
- Management and administration of Models
- Working with Modeling Content in a Project
- Creating and Manage Projects
- Enabling Access to External Data
- Working with GIT Within the SAP Web IDE
- Migrating Modeling Content
- Security in SAP HANA Modeling
- Understanding Roles and Privileges
- Defining Analytic Privileges
- Defining SAP Implementation & Modeling with HANA Roles
- Masking Sensitive Data
- Anonymizing Data
- Introduction to Advanced Modeling