Key Features

Hands-on projects execution

Expert Assistant

24/7 Server access

Project explanations and placements

Instructor led Training

High Quality e-learning

Resume preparation guidance

SAP HANA Modeling and Implementation

What is this course about?

SAP HANA is a High Performance Analytical Appliance which provides platform to build powerful, ground breaking innovations. It gives flexibility in creating analytical models on real time date from business applications. We can further enhance operational analytics with SAP HANA interfaces to Client reporting tools such as BI-Microsoft excel and SAP BO. Its In-Memory data storage provides powerful features like significant processing speed, the ability to handle big data, predictive capabilities and text mining capabilities.

Prerequisites: None

SAP HANA Technology Overview

  1. SAP HANA Introduction
  2. Understanding the need of In Memory Technologies
  3. Understanding High performance Analytics
  4. In-Memory Computing
  5. Hardware-Innovations
  6. Software –Innovations
  7. HANA Columnar Store
  8. SAP HANA row store vs Columnar store
  9. Understanding Columnar Storage
  10. Finding SAP HANA Information Sources

SAP HANA Versions

  1. HANA1.0 SPS03..... SPS12
  2. HANA 2.0 SPS00 ... SPS01

SAP HANA Editions

Software Packaging
  1. SAP HANA Platform Edition based Scenarios
    Software components offered
  2. SAP HANA Enterprise Edition
    Software components offered

SAP HANA Deployment Scenarios

  1. HANA as DataMart
  2. Non-Native HANA Applications
  3. Native HANA Applications
  4. HANA Accelerator
  5. HANA Big Data Solutions
  6. HANA Edition Applications
  7. Describing SAP HANA Roadmap and Scenarios


  1. Look and Feel
  2. Different Perspectives
  3. Administration Console
  4. Modeler
  5. Application Development
  6. Catalog
  7. Content
  8. Security

SAP HANA Implementation Landscape

  1. HANA Database
  2. HANA Client
  3. HANA Studio
  4. Data sources
  5. Replication Technologies
  6. Reporting Tools

SAP HANA Architecture

  1. Simplified Architecture of SAP HANA
  2. SAP HANA Memory Management and Data Persistence


  1. Data Replication –Definition
  2. Data Replication Methods

Uploading Data from Flat files

  1. When to use Flat file upload Functionality
  2. How to load data from Flat file in Workstation
  3. How to load data from Flat File in server

SAP BO-Data services

  1. Introduction to BODS
  2. Data services –One stop solution
  3. Data Integration ,Data Quality , Data Profiling
  4. Metadata management and Text data analysis
  5. Working with BODS
  6. BODS server
  7. Repository
  8. Job server
  9. Management Console
  10. Data services Designer
  11. Creating Formats
  12. Creating Datastores
  13. Creating projects
  14. Creating batch jobs
  15. Scheduling and monitoring Batch jobs
  16. Creating Dataflows
  17. Creating Connection to HANA Db

Implementation Scenarios


  1. Loading Data from Excel File to HANA Database table
  2. Loading Data from Flat File to HANA Database table
  3. Using Template tables
  1. Loading Data from Oracle Database to HANA Database
  1. Loading Data from SAP ECC to HANA Database with Dataflow
  1. Loading Data from SAP ECC to HANA Database With ABAP Dataflow
  1. Loading Data from SAP BW to SAP HANA Database
  1. Loading Metadata from SAP ECC to HANA Database

Data Provisioning Using SLT

  1. SAP Landscape Replication server for HANA
  2. Key benefits of SLT replication server
  3. Key benefits of Trigger-Based Approach
  4. Architecture for SAP source replication
  5. Architecture for Non-SAP source replication
  6. Configuration and monitoring Dashboard for HANA(LTR)
  7. Creating new Configuration for SAP Sources
  8. Creating New Configuration for Non-SAP sources
  9. Result of Creating new Configurations
  10. Launching Data provisioning UI in HANA studio
  11. Start Load/Replication
  12. Stop/Suspend replication
  13. Status Monitoring in HANA Studio
  14. SLT based transformation Concept
  15. Advanced replication settings
  16. Change of table structuring and partitioning
  17. Filtering and selective data replication

Data Provisioning using SAP Direct Extractor Connection (DXC)

  1. Overview
  2. DXC Concept
  3. Challenges
  4. DXC benefits
  5. Activation mechanism for handling Delta Processing
  6. Data source Extractor Concept
  7. SAP Business Content Data source Extractors
  8. SAP HANA DXC Connection setup and Configuration
  9. Activating Data sources in Source system
  10. Understanding the tables of IMDSO
  11. Creating info package and Scheduling data load
  12. Monitoring Data loads
  13. Comparisons with other data acquisition techniques
  14. DXC sidecar approach

SAP HANA Modeling

  1. General DWH concepts
  2. Importance of Data Modeling
  3. ER model
  4. Multi-Dimensional Model
  5. Star Schema
  6. Implementing Data models in BW
  7. Implementing Data models in HANA
  8. Introduction to Modeler
  9. Levels of Modeling

Attribute Views (Deprecated)

  1. Time Dimension Attribute Views
  2. Derived Attribute Views
  3. Shared Attribute Views
  4. Calculated Columns
  5. Hidden Attributes
  6. Using Hierarchies
  7. Implementing Leveled Hierarchies
  8. Parent Child Hierarchies
  9. Applying Filters

Analytic Views (Deprecated)

  1. Multi-Dimensional Model with Analytic views
  2. Calculated Measures
  3. Calculated Attributes
  4. Restricted Measure
  5. Concept Variables and Input parameters

Calculation views

  1. Graphical Calculation views
  2. Create Dimension and Cube Calculation Views
  3. Using Union, Join, Projection, Aggregation, Rank Nodes
  4. Scripted Calculation views
  5. Approaching HANA modeling
  6. Choosing Views for the Information Model
  7. Connecting Tables
  8. Using Inner Join, Left outer Join, Right Outer Join
  9. Full Outer Join, Text Join, Referential Join, Dynamic Joins


  1. Introduction
  2. SQL Elements
  3. Comment and Code page
  4. Functions
  5. SQL Statements
  6. Create table, Alter, Drop
  7. Insert, Update, Delete
  8. Select Statement
  9. SQL script and procedures
  10. Creating procedures
  11. Creating Table types
  12. Calling Procedures
  13. Using CE-Functions
  14. Control Statements

Using Currency Conversions

  1. Understanding Currency Conversions in SAP HANA
  2. Applying Currency Conversions

Create Decision Tables

  1. Decision table for implementing Business rules
  2. Decision table for What-If Analysis

Working with Web IDE

  1. Creating Content procedures
  2. Creating calculation views
  3. Processing Information Objects
  4. Validate Models
  5. Compare Versions of Information objects
  6. Checking Model references
  7. Generate Auto Documentation
  8. Managing Model Content
  9. Manage Schemas
  10. Import & Export Models
  11. Developer Mode
  12. Delivery unit mode
  13. Support mode
  14. Translating Metadata Text

Security and Authorizations

  1. HANA privileges
  2. Creating users
  3. Creating Roles
  4. Assigning privileges and Roles to users
  5. Creating Analytic privileges
  6. Migrating Analytic privileges


  1. SAP HANA Database Connectivity options
  2. Relational Connection with HANA Db
  3. OLAP Connection with HANA Db
  4. Microsoft Excel
  5. Lumira (Visual Intelligence)
  6. SAP BO Analysis for Office
  7. Using IDT
  8. Creating Connection, Data foundation, Business layer
  9. Creating Webi Documents
  10. Dashboards
  11. Crystal Reports for Enterprise

Virtual Data Models in SAP HANA

  1. Use SAP HANA Live
  2. Overview of Virtual Data Models built with Core Data Services (CDS)
  3. Exploring SAP supplied virtual data models (HANA Live and CDS)
  4. Getting Started with SAP HANA Live
  5. Understanding the Virtual Data Model
  6. Discovering and Consuming SAP HANA Live Views
  7. Modifying SAP HANA Live Models
  8. Building a Virtual Data Model with CDS Views
  9. Define Spatial Processing, Text Search and Analysis, Predictive modeling, Graph modeling

Management and administration of Models

  1. Validate Information Models
  2. Transport Information Models
  3. Rename, copy move models
  4. Define schema mapping
  5. Convert Deprecated Modeling artifacts using migration tools

Optimization of Models

  1. Apply Best Practices to Model Design
  2. Introduction to Plan Visualizer and Explain Plan tools