SAP HANA

You will learn SAP HANA through hands-on activities in this SAP HANA course in Pune. Everything in this SAP HANA course is set up so that you can learn everything and do all the hands-on tasks.

SAP HANA is an in-memory database that has great speed and lets you make choices and take steps in real time based on data. Setting up a system and a database is just the beginning of what this course will cover. It will also go over more advanced topics like data licensing, data loading, and models in SAP HANA.

Syllabus:

• Module 01 - Introduction To SAP HANA Studio
• Modeler, Administration View, Navigator, System Monitor
• Module 02 - Architecture of SAP HANA
• Row Store
• Column Store
• Database engine of HANA
• Data modeling
• Reporting
• Architecture
• Administration
•  Module 03 - 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
•   Module 04 - 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
•   Module 05 - 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
•   Module 06 - 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
•   Module 07 - 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
•   Module 08 - 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
•   Module 09 - 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

You Will Learn:

•  Introduction To SAP HANA Studio
•  Architecture of SAP HANA
•  Modeling in SAP HANA
•  Reporting
• Data Provisioning Or Data Loading
• Administration in SAP HANA
• User Management & Security
• COPA Accelerator
•  SAPBW on HANA