Online access for sap hana - Hyderabad

SAP HANA 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
•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, Right Outer Join & cardinalities
•Auto Documentation of Information Models

Reporting

•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
•Create Data Services Job and Load the data to SAP HANA DB

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

User Management & Security

•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.

SAP BW 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