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.
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 you will learn?
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
Hana Navigation and Interface
- In-Memory Computing Studio
- Administration view
- Navigator View
- System Monitor
- Information Modeler
Architecture
- Hana Engine Overview
- IMCE surroundings
- Different HANA Engine Types
- Row Store
- Column Store
- Persistency Layer
- Business Impact of new architecture
- Backup & Recovery
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
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
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
Security
- Creating Users
- Creating Roles
- Privileges
- User Administration
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
Hot Topics
- BW 7.3 powered by HANA Overview
- Rapid Deploy Solutions Overview
- HANA Innovations
- Information Composer
- End to End COPA Scenario
- Exercises