Wat is SAP HANA 2.0 SPS05 Modeling
This course teaches the core capabilities of SAP HANA for calculation view modeling, and covers mainly graphical modeling, as well as SQL-based modeling (table functions and procedures) with a focus on performance. It also introduces Core Data Services as a flexible method to model a persistence layer.
The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context.
We also provide a quick overview of advanced data processing in the areas of text, spatial, predictive and graph modeling, Course based on software release: SAP HANA 2.0 SPS05
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
-
Contents:
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
