About this Course

This session seeks to aid particiapnts in optimizing reporting performance using SAP HANA. It builds on the introductory-level training and presents more advanced modelling and structuring techniques. The objective is to enable students to create ever more efficient reporting applications.

Audience Profile

• Data Modeling Consultants
• Project team members
• Data Modeling Consultants

At Course Completion

Upon completing the course, students will be able to:

• Implement information models in SAP HANA
• Replicate data using SAP Landscape Transformation (SLT)
• Load data using SAP Data Services

Prerequisites

• Completion of SAP Course HA100, SAP HANA - An Introduction

Course Outline

• Approaching SAP HANA modeling

• Connecting tables

• Advanced modeling features including

  • Hierarchies
  • Restricted & calculated measures
  • Filter operations and variables
  • Calculation views
  • Currency conversion

• Introduction to SQL script and script based calculation views

• Full text search

• Processing information models

• Managing modeling content

• SAP HANA user management and privileges

• Trigger-based replication with SAP Landscape Transformation (SLT)

• Data provisioning using SAP Data Services

• Uploading data from flat files

• Utilizing SAP Direct Extractor extraction (DXC)