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

SAP HANA Course


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.

Topics

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
2. IMCE Clients – ODBO,ODBC,JDBC,BICS
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


ABAP to SAP HANA

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


About Company

TechiesEra is a quality Training Center of Noida. TechiesEra provides summer training in Noida on Hadoop, MongoDB,CouchDB,NoSql,Dot Net, Android, Java,PHP etc with live projects. TechiesEra is group of highly qualified professionals in the field of IT education & recruitments.

Get in Touch

  • Phone: +91-9821384666
    9560231801 / 9711965544
    0120 - 4292580
  • Email:
    info@TechiesEra.com
  • Address:
    C-33, Sector - 2
    Near By : Niruala Hotel
    Noida - 201301