SAP Hana

SAP Hana Course Content

SAP HANA 2.0 Development and Implementation (SPS1)

HISTORY OF SAP

  • About SAP
  • SAP Releases and Versions
  • What Is SAP ERP
  • SAP Modules

DATA WAREHOUSING TOPICS

  • Star Schema, Snow flake schema, Extended Star Schema
  • OLTP Vs OLAP
  • What EDW?
  • What is ETL?
  • RDBMS Vs IMDB

SAP HANA Features & Introduction

  • Introduction to SAP HANA
  • Importance of SAP HANA IMDB
  • SAP HANA Applications overview
  • SAP HANA Evaluations
  • SAP HANA IMDB storage types
  • Row oriented storage
  • Column oriented storage
  • SAP HANA Compression & Portioning
  • SAP HANA Memory allocations, e.t.c

SAP HANA Architecture

  • Architecture of SAP HANA
  • Importance of In-memory database.
  • Join Engine
  • OLAP Engine
  • Calculation Engine

SAP HANA LICENSING

  • SAP HANA Versions
  • SAP HANA Platform Edition
  • SAP HANA Enterprise Edition
  • SAP HANA Enterprise Extended Edition

HANA Studio

  • What is PERCEPTIVES
  • What is catalog
  • What is Content
  • What is schema & How to create Schema
  • How to create Package
  • How to create Attribute View
  • Importance of Text Join
  • How to create Hierarchies
  • How to create Analytical View
  • Importance of Data Foundation
  • Importance of Save & Activate, Data Preview
  • How to create Calculation View
  • What is Calculation View
  • Importance of Save, Attributes, Measures, Variables
  • Importance of Find Column
  • Importance of UNION/JOIN & PROJECTION
  • Importance of Decision Table
  • Importance of Analytical Privileges
  • Overview on SQL Script related to HANA

SAP HANA Modeling

  • General DWH concepts
  • Importance of Data Modeling
  • ER Model
  • Multi-Dimensional Model
  • Star Schema
  • Implementing Data models in BW
  • Implementing Data models in Hana
  • Levels of modeling

Attribute Views

  • Time Dimension Attribute View
  • Derived Attribute Views
  • Shared Attribute Views
  • Calculated columns
  • Hidden Attribute Views
  • Using Hierarchies
  • Implementing Leveled Hierarchies
  • Parent Child Hierarchies
  • Applying Filters

Analytic Views

  • Analytic Views
  • Multi-Dimensional Model with Analytic Views
  • Calculated Measures
  • Calculated Attributes
  • Restricted Measure
  • Concept Variables and Input Variables

 

Calculation Views

  • Graphical Calculation Views
  • Using Union, Join, Projection, Aggregation
  • Scripted Calculation Views
  • Approaching HANA modeling
  • Choosing Views for Information Model
  • Connecting tables
  • Using Inner Join, Left Outer Join, Right Outer Join
  • Full Outer Join, Text Join, Referential Join, Union.

SAP HANA SQL

  • HANA SQL DDL
  • HANA SQL DML
  • HANA SQL DCL
  • SAP HANA Referential Join
  • Procedures
  • Creating Table Types
  • Calling Procedures

CE-Functions

  • Control Statements
  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • ETC..

IMPLEMENTATION SCENARIOS

  • Loading Data from Excel File to HANA Database Table
  • Loading Data from Flat File to HANA Database Table
  • Using Template Tables
  • Loading Data from Oracle Database to HANA Database
  • Loading Data from SAP ECC to HANA Database
  • Loading Data from SAP BW to HANA Database
  • Loading metadata from SAP ECC to HANA Database

ETL BASED DATA Provisioning USING BODS

  • Data Services-One stop solution
  • Data Integration, Data Quality, Data Profiling
  • Metadata management and Text data analysis
  • Working with BODS
  • BODS Server
  • Repository
  • Job Server
  • Management Console
  • Data Services Designer
  • Creating Formats
  • Creating Data stores
  • Creating projects
  • Creating Batch jobs
  • Scheduling and monitoring Batch jobs
  • Creating Dataflows
  • Creating Connection to HANA DB

DATA PROVISIONING USING SLT

  • SAP Landscape Replication server for HANA
  • Key benefits of SLT Replication server
  • Key benefits of Trigger-Based Approach
  • Architecture for SAP source Replication
  • Architecture for Non-SAP source Replication
  • Configuration and monitoring Dashboard for HANA(LTR)
  • Creating new Configuration for SAP Sources
  • Creating new Configuration for Non-SAP Sources
  • Result of Creating New Configuration
  • Launching Data provisioning UI in HANA studio
  • Start Load/Replication
  • Stop/Suspend Replication
  • Status Monitoring in HANA Studio
  • SLT based transformation Concept
  • Advanced Replication Settings
  • Change of table Structuring and Partitioning Filtering and Selective data replication

 

  • Web Based Development Workbench
  • Advance Modelling topics
  • SAP BOBJ Lumira Dashboard/story board

END – To – End Implementation Examples

 

SAP HANA (Security & Authorizations)

  • HANA Privileges
  • Creating Users
  • Normal Users Vs Restricted Users
  • Creating Roles
  • Normal Run Time Roles Vs Design Time Roles
  • Assigning Privileges and Roles to Users

Security & Authorizations

  • User Creation
  • Role Creation
  • How to assign role to user
  • How to assign Analytical privileges to role

Transport Management

  • Introduction to Transport Connection
  • Overview on SAP Transport Connection
  • HANA Transports

Different Types of Privileges

  • System
  • SQL
  • Package

Granted Role