Call :+91 8055223360
Menu
Call :+91 8055223360
SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as database server is to store and retrieve data as requested by the applications.
Duration of Training : 50 hrs
Batch type : weekdays /weekends/ Customized Batches
Mode of Training: Offline / Online / Corporate Training
Projects Given : 2 Projects minimum
Trainer Profile : Experienced Faculty from IT Industry
Projects | Assignment | Scenarios and Used Case Studies
SAP HANA combines an ACID-compliant database with application services, high-speed analytics, and flexible data acquisition tools in a single, in-memory platform. As an in-memory database, SAP HANA stores and retrieves data used by applications. It can also act as a modern-day warehouse, integrating data from a wide variety of data sources with live transactional data to deliver up-to-date insights. Built-in application services support the development and deployment of new business apps that exploit data from the digital highway and leverage advanced data processing – text search and analytics, predictive analytics, spatial data processing, graph data processing, and streaming analytics – to deliver deeper insight from Big Data and the Internet of Things at unprecedented speed
No Prerequisite . We will start from Basic
Modeler, Administration View, Navigator, System Monitor
Row Store
Column Store
Database engine of HANA
Data modeling
Reporting
Architecture
Administration
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
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
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
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
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 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
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
Course completion certificate and Global Certifications are part of our all Master Program
Course completion certificate and Global Certifications are part of our all Master Program
Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.
Radical Technologies is a recognized leader in training of Administrative and Soft ware Development courses since 1995 to empower IT individuals with competitive advantage of exploiting untapped jobs in IT sector
