SAP HANA Training

The best SAP HANA Training in Coimbatore is here. SAP HANA is an ever-changing and pre-eminent product in the history of SAP. SAP HANA is widely used by many top companies etc as a real-time application for a decision-based approach and is becoming popular in small businesses as well.

SAP HANA online training from Spark Databox SAP HANA training in Coimbatore will ensure that you understand the basics of SAP HANA and learn and use real-time analytics.

Curriculum:

• Section 1: SAP HANA Studio
  •  Modeler, Administration View, Navigator, System Monitor
• Section 2: The architecture of SAP HANA
  •  Row Store
  •  Column Store
  •  The database engine of HANA
  •  Data modeling
  •  Reporting
  •  Architecture
  •  Administration
• Section 3:  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
  •  Metadata 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
• Section 4:  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
• Section 5:  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 Datastore for ECC and HANA
• Section 6:  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
• Section 7:  User Management & Security
  •  Distributed System Handling – Cold backup and Hot Backup
  •  Persistence 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
• Section 8:  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
• Section 9:  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
  •  SAP BW Composite provider on HANA model