Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

SAP HANA SPS05 Modeling

Základní info

Popis kurzu

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.


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.

Určeno pro


  • Application consultant

  • Data Consultant / Manager

  • Database Administrator

  • Application Developer

  • BI specialist

Obsah kurzu


  • 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

Předpoklady

Essential



  • HA100 SAP HANA - 360° Introduction


Recommended



  • HA150 SAP HANA 2.0 SPS05 - SQLScript for SAP HANA

Studijní materiály

V angličtině

SAP HANA SPS05 Modeling

Vybraný termín:

25.10.2021  ONLINE

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je čtyři a devět ? Součet zapište číslicemi.
SAP