• 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 Roles
  • Masking Sensitive Data
  • Anonymizing Data
• Introduction to Advanced Modeling

• This course will prepare you to:
  • Develop information models following SAP best practices for maximum performance and flexibility
  • Get started with SQL and SQLScript based modeling
  • Manage projects and modeling content in the Web IDE
  • Implement security and data access controls around SAP HANA data models
  • Get a quick overview of advanced data processing such as text, spatial, predictive and graph

• Business application consultant
• Data Consultant / Manager
• Database Administrator
• Application developer
• BI specialist

Essential

• HA100 – SAP HANA Introduction

Recommended

• HA150 – SQL and SQLScript for SAP HANA