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.

Course information

  • 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

Find a course date

Can't find a suitable date?

Booking for 1-2 people?

Make a request for us to schedule training around what works for you? We will do our best to consider your request.

Request a training date

Booking for 3+ people?

Our 3 to RUN initiative empowers you to schedule our chosen classroom training course or virtual SAP Live Class on a date that suits you. You need at least three confirmed participants to register and SAP will add it to your schedule.

Find out more

This course is also available as a test system within SAP Live Access

Learn more