SAP HANA

by Technogeeks

You will learn SAP HANA through hands-on activities in this SAP HANA course in Pune. Everything in this SAP HANA course is set up so that you can learn everything and do all the hands-on tasks.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Technogeeks Logo

img Duration

40 Hours

Course Details

You will learn SAP HANA through hands-on activities in this SAP HANA course in Pune. Everything in this SAP HANA course is set up so that you can learn everything and do all the hands-on tasks.

SAP HANA is an in-memory database that has great speed and lets you make choices and take steps in real time based on data. Setting up a system and a database is just the beginning of what this course will cover. It will also go over more advanced topics like data licensing, data loading, and models in SAP HANA.


Syllabus:

  • Module 01 - Introduction To SAP HANA Studio
  • Modeler, Administration View, Navigator, System Monitor
  • Module 02 - Architecture of SAP HANA
  • Row Store
  • Column Store
  • Database engine of HANA
  • Data modeling
  • Reporting
  • Architecture
  • Administration
  •  Module 03 - 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
  •   Module 04 - 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 05 - 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
  •   Module 06 - 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
  •   Module 07 - 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
  •   Module 08 - 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
  •   Module 09 - 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

 

You Will Learn:

  •  Introduction To SAP HANA Studio
  •  Architecture of SAP HANA
  •  Modeling in SAP HANA
  •  Reporting
  • Data Provisioning Or Data Loading
  • Administration in SAP HANA
  • User Management & Security
  • COPA Accelerator
  •  SAPBW on HANA
  • Aundh Branch

    3rd Floor, Plot 7, Common wealth Society Opposite Aundh Telephone exchange Landmark : Gaikwad Petrol Pump, Aundh, Pune

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy