Duration
5 days
Agenda
Time
Day 5
9.00am – 9.15am
Sign in and start class
9.15am – 10.30am
Information Views
Modeling Functions
CDS in SAP HANA Modeling
Management and administration of Models
Security in SAP HANA Modeling (cont.)
10.30am – 10.40am
Morning break
10.40am – 1.00pm
Using Nodes in Calculation Views
Modeling Functions (cont.)
CDS in SAP HANA Modeling (cont.)
Management and administration of Models (cont.)
Introduction to Advanced Modeling
1.00pm – 2.00pm
Lunch break
2.00pm – 4.00pm
Using Nodes in Calculation Views (cont.)
Using SQL in Models
Optimization of Models
Exercise
Introduction to Advanced Modeling (cont.)
4.00pm – 4.10pm
Afternoon break
4.10pm – 5.00pm
Exercise
Using SQL in Models (cont.)
Exercise
Optimization of Models (cont.)
Exercise
Security in SAP HANA Modeling
Exercise
Goals
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 SAP Web IDE for SAP HANA
- 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
Audience
- Application consultant
- Data Consultant / Manager
- Database Administrator
- Application Developer
- BI specialist
Prerequisite
Essential
HA100 SAP HANA - 360° Introduction
Recommended
HA150 SAP HANA 2.0 SPS05 - SQLScript for SAP HANA
Content
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.