Reading Time: 3 minutes


    Module 1: 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
    • 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

    Module 2: Data 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 3: Data Provisioning or Data Loading

    • 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

    Module 4: 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

    Module 5: 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

    Module 6: COPA Accelerator

    • COPA Overview COPA Reporting in HANA
    • Architecture for CO-PA Accelerator, Use Case Scenarios , Scope
    • DBSL – Data Shared Library Connection for HANA as a secondary Database
    • SLT Replication – SAP HANA Model

    Module 7: SAP BW on HANA

    • Overview of SAP BW
    • SAP BW Powered By HANA as a database
    • In Memory Optimized Info Cube
    • In Memory Optimized DSO
    • Bex Report on SAP HANA Transient Provider
    • SAP BW Composite provider on HANA Model

    Module 8: SAP S4 HANA

      S4HANA A New Product :
    • The First Contact to S4HANA
    • Impact on SAP HANA Business Processes
    • SAP HANA Architecture and Technical Basic Concept
      Excercise 2 :
    • First View in the SAP HANA Database
    • SAP Simple Finance as an instance of a new Application
    • Introduction into Simple Finance:
    • Posting with SAP Fiori
    • Ways to S/4 HANA
    • Lesson Customer Code Migration from ERP Finance to SAP Simple Finance
    • SAP Simple Finance as an instance of a new Application
    • Introduction into SAP Fiori
    • Fiori Launch Pad