SAP HANA 2.x  COURSE CONTENTS:

SAP HANA Introduction:

• Introduction to SAP HANA

• SAP HANA Architecture

• SAP In-Memory Strategy

Architecture:

• Architecture Overview

• Row Store

• Column Store

• Data Modeling

• Reporting

• Persistent Layer

• Backup & Recovery

SAP HANA Modeling:

• ­ Persistency Considerations

• ­ SAP HANA Engine Overview

• ­ Choosing Views for the Information Model

Connecting Tables:

• Joint Types -  Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, Text Join and referential Join

• ­ Explain how using Standard Union and Union with constant values.

Advanced Modeling:

• Creating Attribute Views

  • Derived Attribute Views

  • Calculated Attributes

  • Time Characteristics Based Attribute Views

  • Stand Alone Text Tables

  • Using Base Table Aliases

  • Hidden Attributes

• Using Hierarchies

  • Implement Leveled Hierarchies

  • Leverage Parent Child Hierarchies

  • Create Attribute Based Hierarchies

Advanced Modeling:

• SAP HANA SQL - Introduction

• ­Introduction to SQLScript

• Overview of SQL Script Extensions

• ­SQLScript implementation logic

• ­Creating Database Procedures and design time procedures

• Creating Scalar Functions and Table Type Functions

• ­Introduction to calculation engine and calculation model

• ­Introduction to Calculation engine operators

SQL Script and Procedures:

• Calculated Attributes in Calculation Views

• â??Simpleâ?? Calculation Views

• Aggregation Node

• Unmapped Columns in a Union Node

Creating Calculation Views:

• ­Overview SQL Language Elements

• ­Identifiers

• ­SQL Data Types

• ­Predicates and Operators

• ­Functions and Expressions

Currency Conversion:

• Understand Currency Conversion in SAP HANA

• Apply Currency Conversion in Analytic Views

• Leverage Fixed Currencies

• Create Target Currency Variables

• Use Currency conversion in Calculation Views

Security and Authorizations:

• User Management & Security

  • ­User and Role Concept,

  • ­User and Role Creation,

  • ­Manage User or Role,

  • ­Grant and Revoke User or Role,

  • ­Assign Privilege to User or Role.

  • ­Handle User Management And User Provisioning

• ­Authentication Methods

• ­User and Role Concept in SAP HANA

• ­Maintain Userâ??s Roles

• ­Maintain SAP HANA Privileges

• Types of Privileges

  • ­Authorization Concept

  • ­SQL Privilege

  • ­SYSTEM Privilege

  • ­Package Privilege

  • ­Analytic Privilege

  • ­Template Role

Data Provisioning using SLT:

• Positioning and Key Concepts

• Overview on Configuration

  • Set-up of a configuration on the  SAP LT Replication Server

  • Impact of the configuration set-up on the data  replication

• Data Replication at a Glance

  • ­Load and replicate data

  • ­Suspend and resume data replication of certain tables

  • ­Stop and Restart the master job of a configuration in SLT

  • Different option for data replication

  • Transformation of Data

SMART DATA ACCESS:

• Connecting SAP HANA to data sources using SAP HANA Smart Data Access

Data Provisioning using SAP Data Services

• Introduction to SAP Data Services

• Loading data into SAP HANA

• SAP HANA using an ABAP  Dataflow

Data Provisioning using Flat File Upload

• Introduction to Flat File Upload

• Load data from Flat Files into the SAP HANA Database

SAP BI Reporting:

• HANA, Reporting Layer

• Installing HANA Client 32 bit and 64 bit

• Connectivity options

• Business Objects BI 4.2

• Business Objects BI 4.2 Enterprise

• Crystal Reports via ODBC/JDBC Connections

• SAP Business Objects Web Intelligence

• SAP Design Studio to HANA Connection

• Lumira

• Others & MS Excel

Creating AMDP Procedures for ABAP programs