SAP HANA Course Content

Topic

Course Content

SAP HANA Studio Modeler, Administration View, Navigator, System Monitor
Architecture of SAP HANA Row Store
Column Store
Database engine of HANA
Data modeling
Reporting Architecture
Administration
Modeling in SAP HANA Create Attribute Views
Design Analytical Views
Create Calculation Views from multiple analytical Views
Best Practices while Creating Information Models
Performance Optimization techniques in SAP HANA
Currency Conversion
Variables in HANA
Meta data import to SAP HANA Using SAP BODS
Export Models
Import Models
SQL Script
CE Functions
Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
Restricted Measures & Calculated Measures & Calculated Attributes
Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join & cardinalities
Auto Documentation of Information Models
Reporting SAP BI BO 4.0 Reporting Tools connectivity with SAP HANA
IMCE Clients – ODBO , ODBC, JDBC, BICS
Microsoft Excel 2010 Connection to HDB
Create Universe through Information Design Tool using JDBC Connections.
Web Intelligence Document on SAP HANA Universe.
Design studio
Lumira
BO Analysis for Office
BO Analysis for OLAP
BO Explorer
Crystal Reports for enterprise
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
Administration in SAP HANA Backup & recovery
SAP HANA Studio Installation and Configuration
Clients installation
Create ODBC Connections
Monitor HDB
Multi Version Concurrency Control – MVCC
IMDB Installation
User Management & Security
Distributed System Handling – Cold backup and Hot Backup
Persistency Layer
Creating Users
Creating Roles
Assign privileges to Users/Roles
Template Roles
SQL Statements 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.
SAPBW on HANA Overview of SAP BW
SAP BW Powered By Hana as database
In Memory Optimized Info cube
In Memory Optimized DSO
Bex Report on SAP HANA Transient Provider
SAP BW Composite provider on HANA model
SAP HANA FREE ONLINE DEMO

Register for SAP HANA online Demo

We are conducting FREE WeekDay
Live Demo on
28th September 9:00 PM (IST)
CLICK TO REGISTER FOR A DEMO
SAP HANA TUTORIAL