Course announcements

  • This course teaches the core capabilities of SAP HANA for modeling, and covers mainly graphical modeling, as well as SQL-based modeling, mainly 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.

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 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

Audience

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

Prerequisites

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • HA150 – SQL and SQLScript for SAP HANA

Course based on software release

  • SAP HANA 2.0 SPS04

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