SAP HANA – Radical Technologies Bangalore HSR Layout
Open Quick Enquiry
Please Contact Us
rad

SAP HANA

Best SAP HANA Training in Pune by Industry Experts

Duration : 7 weekends

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

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

Our Courses