SAP HANA Course Curriculum

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

  • 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

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

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

Information Designer Tool

  • Understand concepts of Web intelligence
  • Creating Folder
  • Creating Connections
  • Types of Connections Relational and OLAP
  • Creation of Data Foundation
  • Creation of Data Foundation using single source or multiple sources
  • Inserting Tables
  • Making Joins and Types of Join
  • Resolving Loops
  • Creation of Business Layer using Data Foundation
  • Creation of Classes and Objects
  • Exporting the Business Layer into Repository.

Web Intelligence Rich Client

  • Create Web Intelligence documents with Universe
  • Change the Existing Web Intelligence document
  • Restrict Data returned by a query
  • Design a report
  • Enhance the presentation of data in reports
  • Form a report
  • Calculate data with formulas and variables
  • Analyze data
  • Manage and share Web intelligence documents
  • Work with Filters Query and Report level
  • Work with Prompts at Query level
  • Work with Drilling , Purging
  • Work with Breaking, Section, Ranking,
  • Work with Sub Reports
  • Create formulas with characters &date string functions
  • Create hyperlinks
  • Create a Web I Reports on SAP Bex Query using OLAP Connection
  • Converting Table into Graph
  • Creation of Web Intelligence reports using Info cube& BW Query

Crystal Reports

  • Planning a Report with Universe
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a record
  • Applying Section Formatting
  • Applying conditional Reporting
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Using Report Sections
  • Add hyperlinks to a report

Dash Board Designer

  • Creating a Model
  • Adding Interactivity to a model
  • Creating a connected Model
  • Connect to crystal reports data and create dashboard
  • Connect to WEB I Reports data and create dashboard
  • Using Query as a web service and create dashboard
  • Using Query as a web service and create dashboard
  • Use Live Office data and create Dashboard
  • Use Other connectivity components and create Dashboard
  • Create a Dash Board with Alerts
  • Create a Dash Board with Dynamic Visibility
  • Create a Dash Board with all Dash Board Components
  • Create a Dash Board with Query Browser.

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 Conversations in SAP HANA
  • Using Currency 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
  • Assigning Privileges Users & Roles

Course Highlights

  • Project Overview
  • HANA-Functional, Technical, Documentation
  • ECC with SLT Configuration
  • SLT with HANA Configuration
  • BODS with HANA Integration
  • HANA with BO Reporting

BW HANA

  • BW DB2 Migration Process to HANA
  • BW with HANA DB vs DB2

Testimonials

Had very much interest to learn SAP MM training course, so I joined in this centre and paid fees of Rs.12,000 for 45 days duration. Their response was good and I'm highly satisfied with their coaching.

Mr. Deepak

I joined this institute for SAP FICO Training. The trainers are friendly and are clearing all our doubts. I paid Rs11000 for this 3 months course fees. I'm gratified with their service.

Shaikh Imran

In this institution only I had joined HADOOP course, I paid fees of Rs.12,000 for one month duration and they provided study materials also. I preferred daily morning batches and I'm satisfied with their coaching.

Shilpa

I am glad with this institution who offered me fine classes for SAP CRM with the reasonable fees of Rs15000, the duration of class is 2 months, Thanks for the tutors who provided me valuable classes.

Anil Kolla

It's an excellent training with real time experience faculty by mr.shiva sir having 11years of experience. Hadoop is up coming big data related tool database maintenance. i think this gona work out for every developer.....PRIMARK INFOTECH providing this big data concept "hadoop" with good training classes.

Vardhan

I was looking for training institute to get trained in SAP BO and had joined in this institute. Their coaching and training is good and the fee is nominal, even the class timings are convenient.

Suseela
  • SAP BODS

    Duration : 45 days (With Real Time Project)
    Faculty : MR.Shankar 10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HANA(Development & Admin)

    Duration : Regular Batch(45 Days), (4-5 weeks) Weekend Batches With Realtime Examples,(With Real Time Projects)
    Faculty : Mr.Shankar (Real Time Experienced Consultant).
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 24/7 up to 45 Days
    Weekends : Sat & Sun: 10 to 2
  • SAP FI/CO

    Duration : 3 Months(With Real Time Projects)
    Faculty : MR. Raj Kumar, 7+ Yrs real time Experienced Consultant.
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2Months
  • SAP BPC

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr. Srini,14+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2Months
  • SAP S4 HANA Simple Finance

    Duration : 30 days (With Real Time Projects)
    Faculty : Mr. Srini,14+ Yrs real time Experienced Consultant.
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 45days
  • SAP ABAP

    Duration : 3 Months (With Real Time Projects)
    Faculty : Mr.Sridhar 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP MM

    Duration : 45 days (With Real Time Projects)
    Faculty : Mr. Prakash,10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP SD

    Duration : 45 days (With Real Time Projects)
    Faculty : Mr. Jayram, 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HR-HCM

    Duration : 2Months (With Real Time Projects)
    Faculty : Mrs.Rohini 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP Success Factors

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mrs.Rohini 8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP PP /QM

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr. Ramesh,8+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP HYBRIS(Functional & Technical)

    Duration : 40 Days (With Real Time Projects)
    Faculty : Mr. Kiran,10+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP BASIS

    Duration : 30 Days (With Real Time Projects)
    Faculty : Mr. Avinash,5+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • SAP EHS

    Duration : 30 Days (With Real Time Projects)
    Faculty : Mr. Prasad,14+ Yrs real time Experienced
    Material : Free
    Lab : 7AM TO 8PM
    Online Access : 2 Months
  • Digital Marketing

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr.Yedukondalu, 8+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM
  • Data Science

    Duration : 60 Days (With Real Time Projects)
    Faculty : Mr.Aditya,8+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM
  • Hyperion(ESS Base,Oracle Planning & HFM)

    Duration : 45 Days (With Real Time Projects)
    Faculty : Mr.Kumar, 4+ Yrs Realtime Experience.
    Material : Free
    Lab : 7AM TO 8PM