07, Jul, 2019


Duration : 50 Hrs Total Including Complete Lab Practicals

Trainer : Architect / Consultant Having 12+ Y Experience

Availability : Weekends / Online

Prerequisite: No Prerequisite . We will start from Basic to the Advanced

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as database server is to store and retrieve data as requested by the applications.

Best SAP HANA Training in Pune by Industry Experts

Duration : 50 Hrs Total Including Complete Lab Practicals

Trainer : Architect / Consultant Having 12+ Y Experience

Availability : Weekends

Prerequisite: No Prerequisite . We will start from Basic

In Alphabetsystem, we take all prerequisites required to learn SAP HANA   .

Deployable on premise or in the cloud, SAP HANA is the in-memory computing platform that lets you accelerate business processes, deliver more business intelligence, and simplify your IT environment. By providing the foundation for all your data needs, SAP HANA removes the burden of maintaining separate legacy systems and siloed data, so you can run live and make better business decisions in the new digital economy.

How does SAP HANA work?

SAP HANA combines an ACID-compliant database with application services, high-speed analytics, and flexible data acquisition tools in a single, in-memory platform. As an in-memory database, SAP HANA stores and retrieves data used by applications. It can also act as a modern-day warehouse, integrating data from a wide variety of data sources with live transactional data to deliver up-to-date insights. Built-in application services support the development and deployment of new business apps that exploit data from the digital highway and leverage advanced data processing – text search and analytics, predictive analytics, spatial data processing, graph data processing, and streaming analytics – to deliver deeper insight from Big Data and the Internet of Things at unprecedented speed

SAP HANA Course Content


Modeler, Administration View, Navigator, System Monitor

 Architecture of SAP HANA

Row Store

Column Store

Database engine of HANA

Data modeling




 Modeling in SAP HANA

Create Attribute Views

Design Analytical Views

Create Calculation Views from multiple analytical Views

Best Practices while Creating Information Models

Performance Optimization techniques in SAP HANA

Currency Conversion

Variables in HANA

Meta data import to SAP HANA Using SAP BODS

Export Models

Import Models

SQL Script

CE Functions

Hierarchies – Level Based Hierarchies and Parent Child Hierarchies

Restricted Measures & Calculated Measures & Calculated Attributes

Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities

 Auto Documentation of Information Models


SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA


 Microsoft Excel 2010 Connection to HDB

 Create Universe through Information Design Tool using JDBC Connections.

 Web Intelligence Document on SAP HANA Universe.

 Design studio


 BO Analysis for Office

 BO Analysis for OLAP

 BO Explorer

 Crystal Reports for enterprise

 Data Provisioning or Data Loading

SAP LANDSCAPE Transformation – SLT

SAP BODS Load to SAP HANA – ODP Enabled

Data Sources

SAP DXC – Direct Extractor Connection

Flat File Upload to SAP HANA

SAP BODS : Overview Data Services Workbench and Designer

Creating Data store for ECC and HANA

 Administration in SAP HANA

Backup & recovery

SAP HANA Studio Installation and Configuration

Clients installation

Create ODBC Connections

Monitor HDB

Multi Version Concurrency Control – MVCC

IMDB Installation

 User Management & Security

Distributed System Handling – Cold backup and Hot Backup

 Persistency Layer

 Creating Users

 Creating Roles

 Assign privileges to Users/Roles

 Template Roles

 SQL Statements for user management

 Analytical Privileges, Package Privileges, System Privileges, SQL Privileges

 COPA Accelerator

COPA Overview COPA Reporting in HANA

 Architecture for CO – PA Accelerator , Use Case Scenarios , Scope

 DBSL – Database Shared Library Connection for HANA as secondary Database

 SLT Replication – SAP HANA Model


Overview of SAP BW

 SAP BW Powered By Hana as database

 In Memory Optimized Info cube

 In Memory Optimized DSO

Bex Report on SAP HANA Transient Provider

SAP BW Composite provider on HANA model

Call Now Button