SAP HANA

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
  • Anyone working on Reports and Data
  • Database Administrators
  • Data warehouse Experts
  • BW Consultants
  • SAP BO consultants

prerequisites

  • 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. Advanced 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 into 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

It will take just few seconds to see how competitive our prices are ...