SAP HANA

SAP HANA online trainings Course Content:

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

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