BrainShare provides SAP HANA Online Training or In-class course by excellent experienced IT professionals who has plenty of real time experience. Our trainers has good training experience so that best quality output will be delivered. All our faculty is dedicated so that we can complete your course as per the schedule given. We also allow you to record the classes from your end so that you can refer the classes once again when ever is required. we provide classes through online by using world class interactive system. We also give interview support & Technical support. We trouble shoot your problems while you are working. We address your questions during the Online HANA after the course completion. After completion of your course we will help you to clear your interviews and also assist you to get certified on SAP HANA. We will give you 100% Satisfaction and We provide best quality real time online training.

Sap HANA Training Course Contents

1. SAP HANA and Its Evolution

• SAP HANA Introduction

2. SAP HANA Studio:

• Modellor
• Administration View
• Navigator
• System Monitor

3. Architecture of SAP HANA

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

4. 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
• · Procedures
• · Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
• · Restricted Measures & Calculated Measures & Calculated Attributes
• · Joins in SAP HANA: Referential Join, Text Join, Inner Join, Outer Join & cardinalities·

5. Reporting

• · SAP BI BO 4.0 Reporting Tools with SAP HANA
• · Create Universe through Information Design Tool using ODBC and JDBC Connections
• · SAP HANA Universe Best practices – Array Fetch size, Join by SQL Parameters
• · Universe on Tables from HDB
• · Web Intelligence Document on SAP HANA Universe
• · Dashboard Design
• · BO Explorer
• · Visual intelligence
• · Crystal Reports for enterprise

6. Data Provisioning or Data Loading:

• · SAP LANDSCAPE Transformation – SLT
• · SAP BODS Load to SAP HANA – ODP Enabled Data Sources
• · SAP DEC – Direct Extractor Connection
• · Flat File Upload to SAP HANA
• · Sybase replication – Log based replication
• · SAP BODS: Overview Data Services Designer
• · Creating Data store for ECC and HANA
• · Import Metadata from ECC to HANA Using SAP BODS
• · Create Data Services Job and Load the data to SAP HANA Tables
• · Monitor and trace errors in SAP BODS Jobs

7. 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
• · Distributed System Handling – Cold backup and Hot Backup
• · Persistency Layer

8. User Management & Security

• · Creating Users
• · Creating Roles
• · Assign privileges to Users/Roles
• · Template Roles
• · SQL Statements for user management
• · Password policies, reset password
• · Analytical Privileges, Package Privileges, System Privileges, SQL Privileges

9. COPA Accelerator:

• · COPA Overview
• · Architecture for CO – PA Accelerator, Use Case Scenarios, Scope
• · DBSL – Database Shared Library Connection for HANA as secondary Database
• · COPA Reporting in HANA
• · SLT Replication – SAP HANA Model generation

10. SAP BW on HANA

• · Overview of SAP BW
• · SAP BW Powered By Hana as database
• · In Memory Optimised Infocube
• · In Memory Optimised DSO
• · Bex Report on SAP HANA Transient Provider
• · SAP BW Composite provider on HANA models
• · Integrated Planning on SAP BW on HANA