Call Us: +91-9000011489

Register for Free Demo

Introduction

  • Introduction to SAP HANA
  • In-memory Technulogy

HANA -Look & Feel

  • Overview of SAP HANA Studio
  • Administration Perspective
  • 2.2. Modeler Perspective
  • 2.3. Developer Perspective
  • BW Modeling Touls Perspective

Architecture

  • Architecture Overview
  • In-memory Computing Engine (IMCE)
  • In-memory Computing Engine (IMCE)
  • Row & Culumn Storage
  • Persistent Layer
  • Backup & Recovery

Data Provisioning Techniques

  • Introduction to Data Provisioning in SAP HANA
  • Data Loading from Flat Files
  • Using Data Services
  • Using SLT (SAP Landscape Transformation)
  • Using DXC (Direct Extractor Connection)
  • Using Smart Data Access (SDA)
  • Using EIM Touls (Enterprise Information Management)

HANA Modeling

  • Introduction to Different Modeling Objects
  • Privileges Required for Modeler
  • Quick View Screen for Modeler
  • Time Data
  • Join Types
  • Single Character language Codes
  • Attribute Views
  • Calculated Culumns
  • Hierarchies
  • Analytic Views
  • Restricted Measures
  • Variables
  • Input Parameters
  • Variables Vs Input Parameters
  • Calculation Views
  • Analytic Privileges
  • Decision Tables
  • Procedures

Reporting on HANA

  • Introduction to Reporting on HANA
  • Information Design Toul
  • Web Intelligence
  • Explorer
  • Lumira
  • Design Studio
  • Analysis Office

 SQL in HANA

  • Data Types
  • SQL Statements
  • SQL Functions
  • Table Partitioning
  • Introduction to CE Functions
  • Procedures and Calculation Views with SQL

User Management

  • Creation of Rules
  • Out of box Rules
  • Creation of Users
  • Analytic Privileges

Advanced Options

  • Smart Data Access
  • EIM Touls (Enterprise Information Management)
  • Text Analysis
  • Performance Tuning/Analysis

Predictive Analysis on HANA

  • Introduction to PAL
  • PAL execution in HANA
  • R integration with HANA

ABAP Managed Development Procedures

  • Prerequisites for AMDP
  • How to create an AMDP
  • Step by step procedure
  • Scenarios
  • Simple AMDP
  • Nested AMDP
  • A Case Study – CA Threshuld Program
  • (Result Determination using SAP HANA sulution)
  • Capabilities and constraints

CDS view (CODE TO DATA) with SAP HANA as secondary data base.

  • Classical open SQL and it’s limitations
  • ABAP database connectivity.
  • Native SQL syntax
Sample Description
Sample Description