SAP HANA DEVELOPMENT

Home 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

 

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