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.

  • Introduction
  • Architecture
  • Modeling
  • Advance Modeling
  • Data Provisioning
  • Security
  • Reporting
  • Miscellaneous
Introduction and Positioning:

Lesson 1: Introduction to SAP HANA

Lesson 2: SAP HANA Scenarios

SAP HANA Studio
SAP HANA Architecture:

Lesson 1: Architecture

Lesson 2: Persistence Layer

Lesson 3: Backup & Recovery

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

Approaching SAP HANA Modelling

Lesson 1: Best Practice guidelines

Connecting Tables

Lesson 1: Types of Joins

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
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

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

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

Fill the Form