Training Topics Contents Covered are Listed As Below

1.) SAP HANA Studio :
- Modeler, Administration View, Navigator, System Monitor

2.) Architecture of SAP HANA :
- Row Store
- Column Store
- Database engine of HANA
- Data modeling
- Reporting Architecture
- Administration

3.) 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

4.) 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

5.) 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

6.) 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

7.) Adminstration 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
- 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

8.) 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

9.) 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

---