Call Us Now:
+91 9642208877

You are here

SAP Overview

History of SAP

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

SAP HANA Features &Introduction

  • Introduction to SAP HANA
  • Importance of sap HANA IMDB
  • SAP HANA Applications overview
  • SAP HANA Evalutions
  • Detailed discussion of  SAP BWA , SAP HANA and differences
  • SAP HANA IMDB storage types
  • Row oriented storage
  • Column oriented storage
  • SAP HANA Compression & Portioning
  • SAP HANA Memory allocations, e.t.c

SAP HANA Overview

  • Architecture of SAP HANA (Discussing below topics in detail)
  • Importance of In-memory studio
  • SAP HANA Versions Importance of Reporting
  • Importance of Session Mngt
  • Importance of Relational Engine
  • Importance of Request Processing/Execution Control
  • Importance of Managers
  • Importance of Persistence Layer
  • Importance of Disk Storage
  • Importance of Load Controller     
  • Importance of Replication Agent
  • Importance of BOBI 4.

SAPHANALICENSING

  • 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 Description Mapping
  • Importance of Text Join
  • How to create Hierarchies
  • How to create Analytical View
  • Importance of Data Foundation
  • Importance of Logical View
  • 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

ETL BASED DTA 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 Datastores
  • Creating projects
  • Creating batch jobs
  • Scheduling and monitoring Batch jobs
  • Creating Dataflows
  • Creating Connection to HANA Db

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 with Dataflow
  • Loading Data from SAP ECC to HANA Database With ABAP Datalow
  • Loading Data from SAP BW to SAP HANA Database
  • Loading Metadata from SAP ECC to HANA Database

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 Configurations
  • 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

DATA PROVISIONING USING SAP DIRECT EXTRACTOR CONNECTION(DXC)

Overview

  • DXC Concept Challenges
  • DXC benefits
  • Activation mechanism for handling Delta Processing
  • Data source Extractor Concept
  • SAP Business Content Data source Extractors
  • SAP HANA DXC Connection setup and Configuration
  • Activating Data sources in Source system
  • Understanding the tables of IMDSO
  • Creating info package and Scheduling data load
  • Monitoring Data loads
  • Comparisons with other data acquisition techniques
  • DXC sidecar approach.

Reporting

  • MS – Excel based reporting
  • Defining business layer on IDT (Information Design Tool) Environment
  • Webi Reporting on HANA DB
  • Crystal reporting on HANA DB
  • SAP HANA Database Connectivity options
  • Relational Connection with HANA DB
  • Lumira (Visual Intelligence)
  • SAP BO Analysis for office
  • Creating Connection, Data foundation, Business layer
  • Dashboards
  • Publishing HANA Models to SAP BW

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

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
  • Understanding Currency Conversions in SAP HANA
  • Using Corruncy Conversions in SAP HANA
  • Generate auto documentation
  • Import & Export Models
  • Delivery Units
  • Developer mode
  • Support mode
  • Documentation
  • Translations
  • Managing model Content
  • Manage Schemas
  • Security & Authorizations
  • HANA Privileges
  • Creating Users
  • Creating Users
  • Assigning Privileges Users & Roles

Interview Questionnaire, Certification Guidance.....