Course announcements

  • This course teaches the core capabilities of SAP HANA for modeling, and covers mainly Graphical modeling, which is illustrated by the SAP HANA Live virtual data model, 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 SPS03

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
  • SAP HANA Studio Modeling
  • 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
  • SAP Supplied Virtual Data Models
    • SAP HANA Live
    • Embedded Analytics and 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
    • Using SAP Enterprise Architecture Designer
    • 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

Notes

  • Most of the activities of this course rely on the SAP Web IDE for SAP HANA, but graphical modeling in SAP HANA Studio is also covered with a dedicated unit.

CPE Credits

040 Credits

Please note CPE credits are available only for publicly scheduled courses delivered at SAP locations. CPE credits are not available for virtual classroom deliveries or customer specific deliveries.

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

Learn more

Submit your request

Is the course not scheduled? Or looking for other dates and locations that fit your schedule? Let us know what works for you by clicking the button below and select your preferred location. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom, Public Classroom or Any location (Any Physical location except Virtual Classroom.)

Register Interest