SAP HANA Development

 

HANA 100

Introduction

Introduction to SAP HANA

SAP HANA In-Memory Strategy

HANA Compared to BWA

 

Look and feel

In memory Computing Studio Administration views Navigator View

System View

Information Modeler

Architecture Architecture Overview

IMCE and surroundings Row Store

Column Store

Loading data into HANA Data Modeling

Reporting Persistent

Layer Back & Recovery

 

Data Provisioning

Replication Server Replication process Replication Architecture Data services

SAP BODS and HANA.

Basic Data service connection types

New to Data Services 4.0

Full Extractor through ODP. Configure Import server

Create and execute a Data service job to populate H

ANA.

 

Modeling

Purpose of information Modeler. Levels of modeling in SAP HANA. Attribute Views

Calculation Views

Export & Import

 

Reporting

HANA Reporting Layer. 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

 

User Management Creation of Users Creation of Roles

Creation of Role Hierarchy Assignment of users to roles Authentications

IMCE Authorizations

 

SAP HANA300

DATA PROVISIONING USING SLT

Positioning and key concepts Overview on configuration Aspects Data Replication at a glance.

SLT based transformation concepts. Selective Data Replication. Transformation of Data.

Extension of (target) table structure. Specific Considerations.

 

Approaching SAP HANA Modeling

Persistency Considerations

SAP HANA Engine Overview

Choosing views for the information Model.

 

Connecting Tables

How to connect tables Using: Inner Join

Left Outer Join Right Outer Join Full Outer Join Text Outer Join Referential Join Union

 

Advanced Modeling

Creating Attribute Views. Using Hierarchies.

Creating Restricted & calculated Measures. Using Filter Operations

Using Variables

SAP HANA SQL – Introduction. SQL Script and Procedures Using Currency Conversion.

 

Processing Information Models

Validating Models

Comparing Versions of Information Objects

Checking Model References Generating : Auto Documentation.

 

Managing Modeling Concepts

Schemas

Import & Export

Copying Objects

 

Security and Authorizations

User Management & Security Types of Privileges

Template Roles

Administrative