Enquiry Now !      

SAP HANA Training in Pune | Technogeeks | SAP HANA Institutes in Pune

    Duration : 7 weekends

    SAP HANA syllabus
    • 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

      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

      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

      • 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

      • User Management & Security

      Distributed System Handling – Cold backup and Hot Backup

       Persistency Layer

       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

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

      •  
       

       
       
     

abc
Sap Hana


Enquiry Now !