Home
Online Training
SAP HANA Online Training

SAP HANA Training


Introduction to SAP HANA

  • Introduction to SAP In?Memory
  • Strategy and Technology
  • SAP HANA Landscape
  • SAP In?Memory Computing Product
  • Roadmap

Architecture of SAP HANA

  • Row Store
  • Column Store
  • Database engine of HANA
  • Data modeling
  • Reporting Architecture
  • Administration

Modeling in SAP HANA

  • Create Attribute, Analytical & Calculation Views using Analytical Views.
  • Performance Optimization & Best Practices in SAP HANA
  • Variables & Currency Conversion in SAP HANA
  • Meta data import to SAP HANA Using SAP BODS
  • Import & Export Models
  • CE Functions, Procedures & SQL Scripting.
  • Types of Hierarchies & Types of Measures.
  • Restricted Measures & Calculated Measures & Calculated Attributes
  • Different types of Joins in HANA.

Reporting

  • SAP BI BO Reporting Tools connectivity with SAP HANA
  • ODBO , ODBC, JDBC, BICS & MS EXCEL Connection to HDB
  • Create Universe through Information Design Tool using JDBC Connections.
  • Web Intelligence Document on SAP HANA Universe.
  • Lumina & Design studio
  • BO Analysis for OLAP & Office
  • BO Explorer & Crystal Reports

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
  • Create Data Services Job and Load the data to SAP HANA DB

SAP HANA Administration

  • Backup & recovery
  • SAP HANA Studio Installation, Configuration & Clients installation
  • ODBC Connections & Monitor HDB
  • Multi Version Concurrency Control - MVCC
  • IMDB Installation
  • Cold backup and Hot Backup

User Management & Security

  • Creation of Users & Roles & Role Hierarchy
  • Assigning users privileges & Template Roles
  • SQL 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.

SAP BW on HANA

  • SAP BW Powered By Hana as database
  • In Memory Optimized Info cube & DSO
  • Bex Report on SAP HANA Transient Provider

SAP HANA Studio

  • Modeler
  • Navigator & Administration View
  • System Monitor