SAP HANA
Hands-on Training
Guaranteed Work Experience
Recruitment
Book a Free Consultation
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
HANA SQL Intro
Functions & Expressions
Procedures
Debugging & Troubleshooting SQL script
Full-Text Search
Hierarchies
Restricted & Calculated Measures
Filter Operations and Variables
Security
Creating Users
Creating Roles
Privileges
User Administration
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
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
Rapid Deploy Solutions Overview
HANA Innovations
Information Composer
End to End COPA Scenario
Exercises
12k+ Successful Students
“Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer malesuada efficitur consequat.”
“Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Mauris bl”
“Nulla porttitor accumsan tincidunt. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vestibulum ante ipsum pr”