Best Online Training

SAP HANA online training course

SAP HANA Introduction

  • Reality with SAP HANA
  • SAP In-Memory Appliance
  • SAP HANA proof Points
  • New business reality and Challenges
  • SAP Naming Update—SAP HANA
  • Hardware Innovations
  • Understanding Columnar Data Storage
  • When to use Column store
  • When to user Row Store
    Avoid Bottlenecks
  • Data Transfer
  • Partitioning
  • Parallel Processing
  • Current—SAP HANA
  • Planned—SAP HANA
  • SAP HANA Compared to BWA
  • SAP HANA Database

SAP HANA Scenarios

  • Application serve ABAP based Scenarios
  • HANA as secondary database
  • HANA as primary database
  • Data marts with SAP HANA
  • Applications on top of HANA
  • SAP BW powered by HANA
  • SAP HANA Cloud


  • Look and Feel
  • Different Perspectives
  • Administration Console
  • Modeler
  • Application Development
  • Catalog
  • Content
  • Security

SAP HANA Licensing

  • SAP HANA Versions
  • SAP HANA Platform Edition
  • SAP HANA Enterprise Edition
  • SAP HANA Enterprise Extended Edition

SAP HANA Implement Landscape

  • HANA Database
  • HANA Client
  • HANA Studio
  • Data sources
  • Replication Technologies
  • BO-Data services
  • SLT Replication server
  • DXC
  • Sybase Replication server
  • Admin workstation
  • End-user Workstation
  • SAP HANA Architecture
  • SAP HANA Persistence layer
  • SAP HANA Backup and recovery


  • Data Replication –Definition
  • Data Replication Methods

Uploading Data from Flat files

  • When to use Flat file upload Functionality
  • How to load data from Flat file in Workstation
  • How to load data from Flat File in server
  • Using Information Composer
  • Uploading Files
  • Composing Views

SAP BO-Data services

  • Introduction to 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 Data stores
  • Creating projects
  • Creating batch jobs
  • Scheduling and monitoring Batch jobs
  • Creating Dataflow
  • Creating Connection to HANA DB

Implementation Scenarios


  • Loading Data from Excel File to HANA Database table
  • Loading Data from Flat File to HANA Database table

Using Template tables


  • Loading Data from Oracle Database to HANA Database


  • Loading Data from SAP ECC to HANA Database with Dataflow


  • Loading Data from SAP ECC to HANA Database With ABAP Dataflow


  • Loading Data from SAP BW to SAP HANA Database


  • Loading Metadata from SAP ECC to HANA Database

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 (LTR)
  • Result of creating new Configurations
  • 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
  • Change of table structuring and partitioning
  • Filtering and selective data replication

Data Provisioning using SAP Direct Extractor Connection (DXC)

  • Overview
  • DXC Concept
  • DXC benefits
  • Activation mechanism for handling Delta Processing
  • Data source Extractor Concept
  • SAP Business Content Data source Extractors
  • SAP HANA DXC Connection setup and ConfigurationActivating Data sources in Source system
  • Monitoring Data loadsComparisons with other data acquisition techniques DXC sidecar approach.

SAP HANA Modeling

  • General DWH concepts
  • Importance of Data Modeling
  • ER model
  • Multi-Dimensional Model
  • Star Schema
  • Implementing Data models in BW
  • Implementing Data models in HANA
  • Introduction to Modeler
  • Levels of Modeling

Attribute Views

  • Time Dimension Attribute Views
  • Derived Attribute Views
  • Calculated Columns
  • Hidden Attributes
  • Using Hierarchies
  • Implementing Leveled Hierarchies
  • Parent Child Hierarchies
  • Applying Filters

Analytic Views

  • Multi-Dimensional Model with
  • Analytic views
  • Calculated Measures
  • Calculated Attributes
  • Restricted Measure
  • Concept Variables and Input parameters

Calculation views

  • Graphical Calculation views
  • Using Union, Join, Projection, Aggregation
  • Scripted Calculation views
  • Approaching HANA modeling
  • Connecting Tables
  • Using Inner Join, Left outer Join, Right Outer Join,
  • Full Outer Join, Text Join, Referential Join, Union


  • Introduction
  • SQL Elements
  • Comment and Codepage
  • Functions
  • SQL Statements
  • Create table, Alter, Drop
  • Insert, Update, Delete
  • Select Statement
  • SQL script and procedures
  • Creating procedures
  • Creating Table types
  • Calling Procedures
  • Using CE-Functions
  • Using Currency Conversions
  • Understanding Currency Conversions in SAP HANA
  • Applying Currency Conversions
  • Processing Information Objects
  • Validate Models
  • Compare Versions of Information objects
  • Checking Model references
  • Generate Auto Documentation
  • Managing Model Content
  • Manage Schemas
  • Import & Export Models
  • Developer Mode
  • Delivery unit mode
  • Support mode
  • Translating Metadata Text
  • Security and Authorizations
  • HANA privileges
  • Creating users
  • Creating Roles
  • Assigning privileges and Roles to users


  • SAP HANA Database Connectivity options
  • Relational Connection with HANA Db
  • OLAP Connection with HANA Db
  • Microsoft Excel
  • Lumira (Visual Intelligence)
  • SAP BO Analysis for Office
  • Using IDTCreating Connection, Datafoundation,Business layer
  • Creating Webi Documents
  • Crystal Reports for Enterprise
  • Crystal Reports 2011
  • Publishing HANA Models to SAP BW


Very well organized and conceived. By following the course, I was able to learn and build on the concepts with minimal questions or frustration. It taught me what I was looking to learn, was well organized, and well-paced. I’m already applying what I learned at work.


The practical exercises were useful in offering ‘hands on’ experience. The interactive atmosphere and live examples used for illustration were refreshing.


Course Reviews


12 ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

  • 60 Days


    •   Live Instructor Led Course
    •   Batch Flexibility
    •   Customized Course
    •   Live Projects
    •   Resume Preparation

      Drop Us A Query

    Contact Training Adviser?


    Free Demo

    Call Us @


    ©2016 4bssolutions. All rights Reserved.DISCLAIMER.

    Show Buttons
    Share On Facebook
    Share On Twitter
    Share On Google Plus
    Share On Linkdin
    Share On Youtube
    Hide Buttons