Course announcements

  • This course is also available in a self-paced e-learning format with an active subscription to the SAP Learning Hub, as HA300E.
  • 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.

Course information

  • Calculation Views
    • Introducing Calculation 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 CUBE with Star Join Calculation Views
    • Extracting Top Values with Rank Nodes
  • Modeling Functions
    • Create Restricted and Calculated Columns
    • Filtering Data
    • Using Variables and Input Parameters
    • Implementing Hierarchies
    • Implement Currency Conversion
    • Defining Time-Based Dimension Calculation Views
  • Using SQL in Models
    • Introducing SAP HANA SQL
    • Query a Modeled Hierarchy Using SQLScript
    • Working with SQLScript
    • Creating and Using Functions
    • Creating and Using Procedures
  • Persistence Layer
    • Defining the Persistence Layer
    • Loading Data into Tables
    • Accessing Remote Data
  • Optimization of Models
    • Implementing Good Modeling Practices
    • Implementing Static Cache
    • Controlling Parallelization
    • Implementing Union Pruning
    • Using Tools to Check Model Performance
    • Developing a Data Management Architecture
  • Management and administration of Models
    • Working with Modeling Content in a Project
    • Creating and Managing 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
  • This course will prepare you to:
    • Develop information models following SAP best practices for maximum performance and flexibility
    • Get started with SQL and SQL-Script 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
  • Application Consultant
  • Data Consultant / Manager
  • Database Administrator
  • Application Developer
  • BI specialist

Essential

  • HA100 SAP HANA - 360° Introduction

Recommended

  • HA150 SAP HANA 2.0 SPS06 - 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