Your Door To The Future.
Learning Today For A Better Tomorrow.


Course Content

Learn how to use SAP HANA from beginner level to advanced techniques which is taught by experienced working professionals. We provide best way to learn SAP HANA concepts with practical knowledge. If you are looking for best SAP HANA Training Institute in Noida then TechiesEra is here to taught you all concepts at expert level with practical manner. We cover all the basic and advance concepts of SAP HANA in our course.


Introduction to SAP HANA

Modeler,Administration View,Navigator

1. Create Attribute Views
2. Design Analytical Views
3. Create Calculation Views from multiple analytical Views
4. Best Practices while Creating Information Models
5. Performance Optimization techniques in SAP HANA
6. Currency Conversion
7. Variables in HANA
8. Meta data import to SAP HANA Using SAP
9. Export Models
10. Import Models
11. SQL Script
12. CE Functions
13. Procedures
14. Hierarchies – Level Based Hierarchies and Parent Child Hierarchies
15. Restricted Measures & Calculated Measures & Calculated Attributes
16. Joins in SAP HANA : Referential Join, Text Join, Inner Join, Right Outer Join cardinalities
17. Auto Documentation of Information Models

Data Reporting

1. SAP BI BO 4.0 Reporting Tools Connectivity with SAP HANA
3. Microsoft Excel 2010 Connection to HDB
4. Create Universe through Information Design Tool using JDBC Connection
5. Web Intelligence Document on SAP HANA Universe
6. Design Studio
7. Lumira
8. BO Analysis for Office
9. BO Analysis for OLAP

Data Provisioning or Data Loading

1. SAP DXC – Direct Extractor Connection
2. Flat File Upload to SAP HANA
3. SAP BODS : Overview Data Services Workbench and Designer
4. Creating Data Store for ECC and HANA
5. Create Data Services Job and Load the data to SAP HANA DB
6. Persistency Layer

User Management and Security

1. Creating Users
2. Creating Roles
3. Assign Privileges to Users/Roles
4. Template Roles
5. SQL statements for user management
6. Analytical privileges, Package privileges, System privileges, SQL Privileges

COPA Accelerator

1. COPA Overview COPA Reporting in HANA
2. Architecture for CO–PA Accelerator, Use Case Scenarios, Scope
3. SLT – Replication – SAP HANA Model


1. SAP HANA Basics and Technical concepts
2. Introducing the SAP HANA Studio
3. Introducing the ABAP Development Tools (ADT)
4. Introducing the EPM Sample Application
5. SAP HANA Secondary Database – Access via Open SQL
6. Preparing for SAP HANA
7. Guided Performance Analysis
8. Performance Rules and Guidelines for SAP HANA
9. Classical Open SQL and its Limitations
10. ABAP Database Connectivity (ADBC)
11. Native SQL Syntax
12. Working with Views in SAP HANA Studio
13. Consuming SAP HANA Views using Native SQL
14. Working with Database Procedures in SAP HANA Studio
15. Calling SAP HANA Procedures in ABAP
    a) Core data Services
    b) ABAP Managed Database Procedures

End of the Course