SAP HANA Training

SAP HANA Training Outline

Overview – SAP HANA

• Explain what SAP HANA is
• Comprehend the HANA components and their arrangement
• Understand for whom is SAP HANA relevant

SAP HANA 1.0: Look and Feel

• Understand concepts such as HANA and SAP In-memory computing
• Understand the structure of SAP HANA studio
• Understand how to configure perspectives
• Understand how to create a package

• Give an architectural Overview
• Explain what is the idea behind the row store, technically and theoretically
• Comprehend what a consultant needs to know about it
• Explain the relationship to performance
• Explain what is the idea behind the column store, technically and theoretically
• Comprehend what a consultant needs to know about it
• Explain the relationship to performance
• Explain the persistence layer

Data Provisioning – Data Services and Replication Server

• Understand how the replication server hooks into an R/3 system
•  Select Tables
• Schedule the loading
• Understand how real-time works
• Explain the difference compared to DataServices
• Load transactional data
• Load master data
• Explain how DataServices could be used to transfer data our of BW or any other system into HANA

SAP Landscape Transformation (LT Replicator) for Data Replication into SAP HANA

• Real-time (and scheduled) data replication, replicating only relevant data into HANA
• Ability to migrate data into HANA format while replicating data in real-time
• Leverages proven SLO technology (Near Zero Downtime, TDMS, SAP LT)

HANA Development/Modeling Hands on exercise

Adding a System

Importing Metadata
• Configuring Data Services for Metadata Import
• Creating Schemas
• Importing Table Definitions
• Adding Connections

Loading Data into Table Definitions
• Suspending Data Load
• Resuming Data Load

Copying Contents Delivered by SAP

Mapping Logical and Physical Schemas

Setting Preferences for Information Modeler

Modeling — SAP HANA Studio

• Explain how the model of HANA looks like
• Use the Information Modeler
• Comprehend which objects we have in NewDB
• Describe the relationship between tables, joins, views, frontend interfaces etc
• Create different types of views
• Add/ remove/ join tables
• Create basic join operations
• Activate and deploy views
• Explain how to save the models which have been set up via the export function.
• Explain the import possibilities.

SAP HANA Information Modeler Features (SAP HANA 1.0 SPS 3)

• Functionality
• Usability
• Content
• Administration

Creating Information Objects
• Creating a Package
• Creating an Attribute View
• Creating an Analytic View
• Creating a Calculation View
• Managing Attribute Mappings
• Constant Column
• Creating an Analytic Privilege
• Creating Functions
• Creating Calculated Attributes
• Using Currency as Unit of Measure
• Adding Variables
• Searching Related Tables
• Using System Generated Joins

Processing Information Objects
• Previewing Data of Information Objects
• Validating Models
• Comparing Versions of Information Objects
• Viewing Version History of Information Objects
• Switching Ownership of Inactive Information Objects
• Generating Object Documentation
• Migrating Old Calculation Views
• Checking Model References
• Exporting Models to a Server
• Importing Models from a Server
• Exporting Models to a Client
• Importing Models from a Client

HANA SP2 Features SQLScript Version 2 (SQLScript v2)

• Simplification of the language landscape
• Enhancing the available programmable containers
• Consolidate the different available languages
• Import/Export/Transport of programmable containers


• Understand connectivity options for reporting on top of Hana
• Understand the BusinessObjects BI4.0 platform and reporting possibilities
• Set up various connectivity to Hana system for reporting

User Management
• You will be able to create new system users and roles, assign read permissions etc.

• Explain the extensible auditing infrastructure
• Show how the Audit trail is stored using syslog
• Explain the concept for Audit logging of authorization changes

Scenario: CO-PA R/3 Scenario: CO-PA

• Understand CO-PA being an example in HANA
• Explain the CO-PA model, related tables, short example of the R/3 reports used in this module etc

Scenario: Build SAP HANA report on MS Excel

• Understand how to load CSV file into SAP HANA
• Explain the model, related tables, short example of the reports used in MS excel

Trouble Shooting — Monitoring, Statistic Server, Trouble Shooting

• See running services
• Judge the disk volume usage
• Watch the system load history etc

A Common Database Approach

• Learn why Column Storage is best suited for modern CPUs
• Understand why Column Storage is suited for update-intensive applications
• Explain the consequences of the insert only approach
• Understand the consequences for typical data entry transactions


104 Industrial Blvd, Suite P,
Sugar Land, TX, 77479

We are located close to Hwy 59 and
Hwy 90 in Sugar Land , TX


Phone : 419 408 3178

Back to Top