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.

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 - SAP HANA 2.0 SPS02 - SQL and SQLScript for SAP HANA

Course based on software release

  • SAP HANA 2.0 SPS02

Content

  • Information Views
    • Connect Tables
    • Create Dimension and Cube Calculation Views
  • Modeling Functions
    • Create Calculated and Restricted Columns
    • Filter Data
    • Use Variables and Input Parameters
    • Create Hierarchies
    • Implement Currency Conversion
  • SAP HANA Studio Modeling
  • SAP Supplied Virtual Data Models
    • SAP HANA Live
    • Embedded Analytics and CDS
  • Using SQL in Models
    • Introduce SAP HANA SQL
    • Define the Persistence Layer Using CDS
    • Work with SQLScript
    • Create and Use Functions and Procedures
  • Optimization of Models
    • Implement Good Modeling Practices
    • Use Tools to Maximize Optimization
  • Management and administration of Models
    • Work with Modeling Content
    • Create and Manage Projects
    • Use SAP Enterprise Architecture Designer
    • Overview of Classical Models Migration to Web IDE
  • Security in SAP HANA Modeling
    • Understand the Key Concepts of SAP HANA Security
    • Define Data Access Security
    • Define Roles
  • Overview of Text, Spatial, Predictive and Graph 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

Register your interest for taking this course

Let us know when and where you'd like to attend and we'll notify you when sessions become available.

Note: Location can be for a public classroom or a virtual that meets your prefered timezone.

Register Interest