logo
Home

HA300 SAP HANA Modeling

  • CMDBID 61077
  • Course Code HA300,SAP,HANA
  • Duration 5 Days
Scroll

SAP Course

course overview

Click to View dates & book now

Overview

This five-day instructor-led 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 an overview of advanced data processing in the areas of text, spatial, predictive and graph modeling. Graphical modeling in SAP HANA Studio is covered with a dedicated unit.

This course is based on software release:

  • SAP HANA 2.0 SPS03

Audience

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

Skills Gained

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

Prerequisites

Essential

  • HA100 – SAP HANA Introduction

Recommended

  • HA150 – SAP HANA SQL and SQLScript for SAP HANA

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Outline

  • Information Views
  • Using Nodes in Calculation Views
  • Modeling Functions
  • Using SQL in Models
  • Core Data Services (CDS) in SAP HANA Modeling
  • Optimisation of Models
  • Management and Administration of Models
  • Security in SAP HANA Modeling
  • Introduction to Advanced Modeling
  • Introducing Information Views
  • Understanding the Different Types of Views
  • Working with Common View Design Features
  • 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
  • Create Restricted and Calculated Columns
  • Filter Data
  • Use Variables and Input Parameters
  • Create Hierarchies
  • Implement Currency Conversion
  • Introducing SAP HANA SQL
  • Working with SQLScript
  • Query a Modeled Hierarchy Using SQLScript
  • Creating and Using Functions
  • Creating and Using Procedures
  • Defining the Persistence Layer Using CDS
  • Creating Views with CDS
  • Using Tools to Check Model Performance
  • Implementing Good Modeling Practices
  • 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
  • Understanding Roles and Privileges
  • Defining Analytic Privileges
  • Defining Roles
  • Masking Sensitive Data
  • Anonymising Data

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.