+91 6300698155 | +1 929-268-1172 | +91 6300698155 | erplearninghub123@gmail.com

SAP HANA Introduction

SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. In SAP HANA, HANA stands for High-Performance Analytic Appliance.

SAP HANA Features Need for SAP HANA

Today, most successful companies respond quickly to market changes and new opportunities. A key to this is the effective and efficient use of data and information by analyst and managers. HANA overcomes the limitations mentioned below,

SAP HANA Training Course Content

  • 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
  • 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
  • REPORTING
  • 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
  • Create Data Services Job and Load the data to SAP HANA DB
  • 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
  • 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
  • COPA ACCELERATOR
  • COPA Overview COPA Reporting in HANA
  • SArchitecture for CO - PA Accelerator , Use Case Scenarios , Scope
  • DBSL - Database Shared Library Connection for HANA as secondary Database
  • SLT Replication - SAP HANA Model
  • SAP BW 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
  • SSAP BW Composite provider on HANA model

Request For a Free Demo