Course Contents

SAP HANA (Duration: 30hrs)

SAP HANA Introduction 

SAP HANA is a flexible, data-source- agnostic appliance that enables customers to analyze large

volumes of SAP ERP data in real-time, avoiding the need to materialize transformations.

SAP HANA is a hardware and software combination that integrates a number of SAP components

including the SAP HANA database, SAP LT (Landscape Transformation) Replication Server, SAP HANA

Direct Extractor Connection (DXC) and Sybase Replication technology. SAP HANA is delivered as an

optimized appliance in conjunction with leading SAP hardware partners.

Unit 1: Introduction and Positioning

Lesson 1: Introduction to SAP HANA

Lesson 2: SAP HANA Scenarios

Unit 2: SAP HANA Studio

Unit 3: SAP HANA Architecture

Lesson 1: Architecture

Lesson 2: Persistence Layer

Lesson 3: Backup & Recovery

Unit 4: Data Provisioning

Lesson 1: Uploading data from Flat Files

Lesson 2: SAP Data Services

Lesson 3: SAP LT Replication Server

Lesson 4: SAP Direct Extractor Connection (DXC)

Lesson 1: Introduction to Modeller Perspective

Lesson 2: Creation of Attribute views

Lesson 3: Creation of Analytic views

Lesson 4: Creations of Calculation views

Unit 6: Approaching SAP HANA Modelling

Lesson 1: Best Practice guidelines

Unit 7: Connecting Tables

Lesson 1: Types of Joins

Unit 8: Advanced Modelling

Lesson 1: Using Hierarchies

Lesson 2: Creating Restricted & Calculated Measures

Lesson 3: Using Filter Operations – Input Parameters

Lesson 4: Using Variables

Lesson 5: Creating Calculation Views – SQL Script/CE function

Lesson 6: SAP HANA SQL – Introduction

Lesson 7: SQL Script and Procedures

Lesson 8: Using Currency Conversion

Lesson 9: Decision Tables

Lesson 10: Processing Information Models

Lesson 11: Managing Modelling Content

Unit 9: Security and Authorizations

Lesson 1: User Management and Security

Lesson 2: Types of Privileges

Lesson 3: Template Roles

Lesson 4: Administrative

Lesson 1: SAP HANA Database connectivity options

Lesson 2: Microsoft Excel

Lesson 3: Semantic Layer with IDT

Lesson 4: Accessing Universe using Crystal Reports

Lesson 5: Accessing Universe using Webi

Lesson 6: Accessing Universe using SAP Lumira

Unit 11: SAP Netweaver BW, powered by SAP HANA

Lesson 1: Introduction

Lesson 2: In-memory Optimized DataStore Object and Infocube

Lesson 3: LSA and LSA++ in times of HANA

Lesson 4: Consuming HANA Models in BW

Lesson 5: BI or BW powered by HANA

Unit 12: Miscellaneous Topics – Overview

Lesson 1: SAP HANA Live Views

Lesson 2: Odata Services

Lesson 3: HANA New features

Exercise: Look and Feel

Exercise: Architecture

Create the Attribute Views

Create the Analytical View for Actual

Create the Analytical View for Plan

Create the Calculation View

Information Composer: Upload data from file system

Information Composer: Compose new Information View

Exercise: Excel Pivot Tables (ODBO/MDX access)

Exercise: Analysis for Office using a local ODBC connection

Exercise: Analysis edition for OLAP

Exercise: SAP Business Objects Explorer

Exercise: Creating a Business Layer using Information Design Tool using JDBC connection.

SAP HANA Advanced Modelling and Implementation Exercise

Exercise: Creating Attribute Views

Exercise: Using Hierarchies

Exercise: Creating Restricted & Calculated Measures

Exercise: Using Filter Operations

Exercise: Using Variables

Exercise: Creating Calculation Views

Exercise: Working with SQL statements

Exercise 8: Creating a simple Calculation View of type SQL Script

Exercise: Creating a Calculation View of type SQL Script using CE_FUNCTIONs

Exercise: Creating Procedures

Exercise: Creating a Calculation View of type SQL Script using procedures

Exercise: Currency Conversions in Analytical Views

Exercise: Using the Fuzzy Search functionality

Exercise: Processing Information Objects

Exercise: Managing Modelling Content

Exercise: Working with SAP HANA users and roles

Exercise: Creating Roles and Analytic Privileges

Exercise: Start, Suspend, Resume the replication

Exercise: Data Acquisition using SAP Data Services

Exercise: Creating a Extractor Connection (DXC)

Exercise: Modelling on Efashion data

POC 1 – COPA Scenario

POC 2 – Finance Scenario



  • Introduction
  • Architecture
  • Modeling
  • Advance Modeling
  • Data Provisioning
  • Security
  • Reporting
  • Miscellaneous

Fill the Form And GET DISCOUNT

Your Name ( * )

Your Email ( * )

Your Number ( * )


Your Message