SAP Hana

WHAT IS IT ABOUT ?

SAP HANA acronym for SAP “High-Performance Analytic Appliance” utilises the new In-Memory technology developed by SAP. SAP HANA is the next generation Application combined database which can power analytical application and provide real time functionality. SAP HANA is highly optimised to connect with the SAP Business Objects (SAP BO) for reporting and creating dashboards.

Course Overview

Who is it for ?


  • IT Analysts
  • Any programming language specialists
  • Reporting Analyst
  • Any one working on Reports and Data
  • Database Administrators
  • Data warehouse Experts
  • BW Consultants
  • SAP BO consultants

Pre Requisites


  • Knowledge of SAP BW
  • Knowledge of SAP BO

What will you learn ?


1. HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History of SAP HANA
  • IMC Products
  • HANA compare to BWA
  • In-Memory Basics
  • HANA Use cases

2. Hana Navigation and Interface

  • In-Memory Computing Studio
  • Administration view
  • Navigator View
  • System Monitor
  • Information Modeler

 3. Architecture:

  •  Hana Engine Overview
  • IMCE surroundings
  • Different HANA Engine Types
  • Row Store
  • Column Store
  • Persistency Layer
  • Business Impact of new architecture
  • Backup & Recovery

 4. Modeling

  • Key Concepts in Data Modeling
  • Components of HANA data model Views
  • Analytical Views
  • Attribute views
  • Calculation Views
  • Connecting Tables
  • Joins
  • Measures
  • Filters
  • Real Time Scenarios
  • Choosing Views for the Information Model
  • Persistency Considerations
  • Variables

5. Advance Modeling

  •  Calculation Views
  • HANA SQL Intro
  • Functions & Expressions
  • Procedures
  • Debugging & Troubleshooting SQL script
  • Full Text Search
  • Hierarchies
  • Restricted & Calculated Measures
  • Filter Operations and Variables

6. Data Provisioning:

  • Overview
  • Trigger Based Replication
  • ETL Based Replication
  • Log Based Replication
  • Intro to BODS 4
  • Basic Data service Connection types
  • Flat File upload in to HANA
  • Create and execute a Data Service Job to populate HANA
  • DXC Overview

7. Security:

  •  Creating Users
  • Creating Roles
  • Privileges
  • User Administration

8. Reporting

  •  Connectivity options
  • Business Objects BI 4
  • Business Objects BI 4 Explorer
  • Business Objects BI 4 Enterprise
  • Crystal Reports via ODBC/JDBC Connections
  • Others & MS Excel

9. Hot Topics:

  • BW 7.3 powered by HANA Overview
  • Rapid Deploy Solutions Overview
  • HANA Innovations
  • Information Composer
  • End to End COPA Scenario
  • Exercises