SAP HANA 2.0

SAP HANA 2.0 

                           We the best in SAP Training , managed by Technical Experts based in Hyderabad, India which does training, and project implementation. We believe in providing best qualitative.

About My Self:                                                          

                          My Name is Rajesh Varma. I am having 12 years of experience in SAP Environment. I started my carrier with SAP BW 3.5, followed on SAP BW 7.0, 7.3, 7.4 and Currently working in SAP BW on HANA.
I am having 4 years of teaching experience in sap BW & SAP HANA & SAP BW On HANA.
As I worked member of COE (center of excellence) for SAP BW & BW On HANA during my carrier with IT companies, I was frequently involved in many training programs, which had been conducted to groom group of fresher's. This activity made me take teaching as a part time profession. However, I still continue working for IT company as a SAP BW On HANA consultant.

SAP HANA 2.0 SP01 Course Content


Course Duration: 35-40 hours Training + Assignments + Actual POC’s (Monday to Saturday -Daily 1 Hour)
Training Materials: All attendees will receive,

  • Assignment after each module, Video recording of every session
  • Notes and study material for examples covered.

Who Should Join this Training:

Any graduate B.Tech/B.E, M.Tech/M.E, MCA, and MBA can learn the SAP BW Analysis skills if you want to understand the reporting needs of your customers or end-users.

Training Format:

This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Got meeting Web and Audio Conferencing tool.

History of SAP
  • About SAP
  • SAP Releases and Versions
  • What Is SAP ERP
  • SAP Modules
  • Comparison between SAP BW 7.4 Vs SAP HANA 1.0
SAP HANA Features & Introduction
  • Introduction to SAP HANA
  • Importance of SAP HANA IMDB
  • SAP HANA Applications overview
  • SAP HANA Evaluations
  • Detailed discussion of SAP BWA,SAP HANA and differences
  • SAP HANA IMDB storage types
  • Row oriented storage
  • Column oriented storage
  • SAP HANA Compression & Portioning
  • HANA compare to BWA
  • Hardware Innovations
  • SAP HANA Memory allocations, e.t.c
HANA Studio Overview
  • Data Provisioning
  • Data Services
  • Generate Auto Documentation
  • Import & Export Models
  • Validate, Activate
  • Translations
  • Managing model Content
  • Manage Schemas
SAP HANA Architecture
  • Architecture of SAP HANA(Discussing below topics in detail)
  • SAP HANA Backup and recovery
  • Applications on top of HANA
  • Importance of In-memory studio
  • SAP HANA Versions
  • Importance of Reporting
  • Importance of Session Mngt
  • Importance of Relational Engine
  • Importance of Request Processing/Execution Control
  • Importance of Managers
  • Importance of Persistence Layer
  • Importance of Disk Storage
SAP HANA Licensing
  • SAP HANA Versions
  • SAP HANA Platform Edition
  • SAP HANA Enterprise Edition
  • SAP HANA Enterprise Extended Edition
SAP HANA Studio
  • What is PERCEPTIVES
  • What is catalog
  • What is Content
  • What is schema & How to create Schema
  • How to create Package
  • How to create Attribute View
  • Importance of Description Mapping
  • Importance of Text Join
  • How to create Hierarchies
  • How to create Analytical View
  • Using Variables, input parameters
  • Importance of Data Foundation
  • Importance of Logical
  • Importance of Save & Activate, Data Preview
  • How to create Calculation View
  • What is Calculation View
  • Importance of Save, Attributes, Measures, Variables
  • Importance of Find Column
  • Importance of UNION/JOIN & PROJECTION
  • Importance of Decision Table
  • Importance of Analytical Privileges
  • Understanding Currency Conversations in SAP HANA
  • Using Currency Conversions in SAP HANA
ETL Based Data Provisioning Using BODS
  • Data services-One stop solution
  • Data Integration ,Data Quality ,Data Profiling
  • Metadata management and Text data analysis
  • Working with BODS
  • BODS Server
  • Repository
  • Job Server
  • Management Console
  • Data Services Designer
  • Creating Formats
  • Creating Datastores
  • Creating projects
  • Creating Batch jobs
  • Scheduling and monitoring Batch jobs
  • Creating Dataflows
  • Creating Connection to HANA DB
Implementation Scenario
  • Loading Data from Excel File to HANA Database Table
  • Loading Data from Flat File to HANA Database Table
  • Extracting Data flat file and loading data to multiple Data targets
  • Using Template Tables
  • Loading Data from SAP ECC to HANA From Multiple Tables
Data Provisioning Using SLT
  • SAP Landscape Replication server for HANA
  • Key benefits of SLT Replication server
  • Key benefits of Trigger-Based Approach
  • Architecture for SAP source Replication
  • Architecture for Non-SAP source Replication
  • Configuration and monitoring Dashboard for HANA(LTR)
  • Creating new Configuration for SAP Sources
  • Creating new Configuration for Non-SAP Sources
  • Result of Creating new Configuration
  • Launching Data provisioning UI in HANA studio
  • Start Load/Replication
  • Stop/Suspend Replication
  • Status Monitoring in HANA Studio
  • SLT based transformation Concept
  • Advanced Replication Settings using T. Code LTRS
  • Change of table Structuring and Partitioning using T. Code LTRS
  • Filtering and Selective data replication using T. Code LTRS
Data Provisioning Using SAP Direct Extractor Connection(DXC) Overview
  • DXC Concept
  • Challenges
  • DXC Benefits
  • Activation mechanism for handling Delta Processing
  • Data Source Extractor Concept
  • SAP Business Content Data Source Extractors
  • SAP HANA DXC Connection setup and Configuration
  • Activating Data Sources in Source system
  • Understanding the tables of IMDSO
  • Creating info package and Scheduling data load
  • Monitoring Data loads
  • Comparisons with other data acquisition techniques
  • DXC sidecar approach
Transport Management
  • Introduction to Transport Connection
  • Overview on SAP Transport Connection
  • HANA Transports
                                 1.  Delivery Units
                                 2.  Developer Mode
                                 3.  Support Mode
                                 4.  LCM - Life Cycle Management
Different Types of Privileges (User Management)
  • Security and Authorizations
  • HANA privileges
  • Creating users
  • Creating Roles
  • Assigning privileges and Roles to users
SAP HANA SQL
  • Introduction,
  • SQL Statements -
  • Select Statement, From Clause, Where Clause, Group By clause So on
  • Using CE-Functions,
  • SQL script and procedures,
  • Creating Table Types
  • Creating procedures 
  • Calling Procedures
    Calculation View
                 Calculation SQL Script method               
                How to call CE functions using SQL into Calculation Views
Advanced Concepts:
  • Smart Data Access
  • Introduction to Smart Data Access
  • Extracting Data from Multiple Sources
  • Creation of Data sources, Virtual Tables
SAP HANA Live

How to Debug on Procedure


SAP BO Reporting Overview ( 5 Days session )
  • MS-Excel based reporting
  • Defining business layer on IDT(Information Design Tool) Environment
  • Webi Reporting on HANA DB
  • Crystal reporting on HANA DB
  • SAP HANA Database Connectivity Options
  • Relational Connection with HANA DB
  • Lumira(Visual Intelligence)
  • SAP BO Analysis for office
  • Creating Connection, Data Foundation, Business Layer
  • Dashboards
  • Design Studio ( 1 Day )
SAP BW On HANA
  • Overview of SAP BW
  • BW Vs HANA
  • Generation of SAP HANA Views
  • Adding BW System & Overview of Eclipsed BW System
  • Creation Of Cube
  • Importing BW Models to HANA
  • Publishing HANA Models to SAP BW


HANA Certification Guidelines

Guiding for SAP HANA Certification - Sample questions and documentation for HANA certification provided (C_HANAIMP_10)
Guiding Resume Preparation & Tracking Interviews..