SAP HANA Coaching In People Click Bangalore

SAP HANA
Course Content
Course Duration: 30-35 Hours
SAP HANA is SAP AG’s Implementation of In-Memory Database
Technology. HANA (High Performance Analytical Appliance) is a New In-
Memory Data Management Appliance released by SAP which is more of
separate plug-in Software & Hardware for faster Analytical Activities.
HANA is pre-configured Analytic Appliance.
SAP HANA is the synthesis of three separate Products TREX (Text
Retrieval & Extraction), P*Time & MaxDB.
But why SAP HANA and not any of the other SAP Modules? SAP HANA not
only provides the capability to extracting data from the various SAP & Non-
SAP System But also facilitates the Data Modeling also. SAP HANA server
as a Central Repository where Business owners pull information, If they are
interested in seeing all aspects of the Project.
Introduction

In-Memory Computing

Evolution of In-Memory Computing at SAP

History of HANA

IMC Products

HANA compare to BWA

Product Availability Matrix
Architecture

HANA Engine Overview

IMCE Surroundings

Different HANA Engine Types

Row Store

Column Store

Presistency Layer

Business Impact of New Architecture
Modeling

Key Concepts in Data Modeling

Components of HANA Data Model

Views
1) Analytical Views
2) Calculation Views
3) Attribute Views

Connecting Tables
1) Joins

Measures

Filters

Common Scenarios

Choosing Views for the Information Model

Presistency Considerations

Variables
Advance Modeling

Calculation Views

Fucntions & Expressions

Procedures

Debugging & Trouble Shooting SQL Script

Hierarchies

Restricted & Calculated Measures

Filter Operations & Variables

Curreny Conversion
Data Provisioning

Overview

Trigger Based Replication

ETL Based Replication

Log Based Replication

Introduction to BODS 4

Basic Data Service Connection Types

Full Extractor though ODP

Create & Execute a Data Service Job to Populate HANA

DXC Overview
Security

Creating Users

Creating Roles

Privileges

User Administration
Reporting

Connectivity Options

Business Objects BI 4.0

Business Objects BI 4.0 Explorer

Business Objects BI 4.0 Enterprise

Crystal Reports via ODBC/JDBC Connections

Others & MS Excel
Miscellaneous

BW 7.3 Powered by HANA Overview

SAP HANA Road Map

SAP HANA Today

SAP HANA 2.0 (Suite)

BW – HANA Relationship

In-Memory DSO & Cube Overviewds