SAP HANA 2.0
We the best in SAP Training , managed by Technical Experts based in Hyderabad, India which does training, and project implementation. We believe in providing best qualitative.
About My Self:
My Name is Chandra. I am having 14 years of experience in SAP Environment. I started my carrier with SAP BW 3.5, followed on SAP BW 7.0, 7.3, 7.4 and Currently working in SAP BW on HANA.
I am having 4 years of teaching experience in sap BW & SAP HANA & SAP BW On HANA.
As I worked member of COE (center of excellence) for SAP BW & BW On HANA during my carrier with IT companies, I was frequently involved in many training programs, which had been conducted to groom group of fresher's. This activity made me take teaching as a part time profession. However, I still continue working for IT company as a SAP BW On HANA consultant.
SAP HANA 2.0 SP01 Course Content
Course Duration: 35-40 hours Training + Assignments + Actual POC’s (Monday to Saturday -Daily 1 Hour)
Training Materials: All attendees will receive,
· Assignment after each module, Video recording of every session
· Notes and study material for examples covered.
Who Should Join this Training:
Any graduate B.Tech/B.E, M.Tech/M.E, MCA, and MBA can learn the SAP BW Analysis skills if you want to understand the reporting needs of your customers or end-users.
Training Format:
This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Got meeting Web and Audio Conferencing tool.
History of SAP
· About SAP
· SAP Releases and Versions
· What Is SAP ERP
· SAP Modules
· Comparison between SAP BW 7.4 Vs SAP HANA 1.0
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
· HANA compare to BWA
· Hardware Innovations
· SAP HANA Memory allocations, e.t.c
HANA Studio Overview
· Data Provisioning
· Data Services
· Generate Auto Documentation
· Import & Export Models
· Validate, Activate
· Translations
· Managing model Content
· Manage Schemas
SAP HANA Architecture
· Architecture of SAP HANA(Discussing below topics in detail)
· SAP HANA Backup and recovery
· Applications on top of HANA
· 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
SAP HANA Licensing
· SAP HANA Versions
· SAP HANA Platform Edition
· SAP HANA Enterprise Edition
· SAP HANA Enterprise Extended Edition
SAP 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
· Using Variables, input parameters
· 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
· Understanding Currency Conversations in SAP HANA
· Using Currency Conversions in SAP HANA
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 Datastores
· Creating projects
· Creating Batch jobs
· Scheduling and monitoring Batch jobs
· Creating Dataflows
· Creating Connection to HANA DB
Implementation Scenario
· Loading Data from Excel File to HANA Database Table
· Loading Data from Flat File to HANA Database Table
· Extracting Data flat file and loading data to multiple Data targets
· Using Template Tables
· Loading Data from SAP ECC to HANA From Multiple Tables
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 using T. Code LTRS
· Change of table Structuring and Partitioning using T. Code LTRS
· Filtering and Selective data replication using T. Code LTRS
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
Transport Management
· Introduction to Transport Connection
· Overview on SAP Transport Connection
· HANA Transports
1. Delivery Units
2. Developer Mode
3. Support Mode
4. LCM - Life Cycle Management
Different Types of Privileges (User Management)
· Security and Authorizations
· HANA privileges
· Creating users
· Creating Roles
· Assigning privileges and Roles to users
SAP HANA SQL
· Introduction,
· SQL Statements -
· Select Statement, From Clause, Where Clause, Group By clause So on
· Using CE-Functions,
· SQL script and procedures,
· Creating Table Types
· Creating procedures
· Calling Procedures
Calculation View
Calculation SQL Script method
How to call CE functions using SQL into Calculation Views
Advanced Concepts:
· Smart Data Access
· Introduction to Smart Data Access
· Extracting Data from Multiple Sources
· Creation of Data sources, Virtual Tables
SAP HANA Live
How to Debug on Procedure
SAP BO Reporting Overview ( 5 Days session )
· 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
· Design Studio ( 1 Day )
SAP BW On HANA
· Overview of SAP BW
· BW Vs HANA
· Generation of SAP HANA Views
· Adding BW System & Overview of Eclipsed BW System
· Creation Of Cube
· Importing BW Models to HANA
· Publishing HANA Models to SAP BW
HANA Certification Guidelines
Guiding for SAP HANA Certification - Sample questions and documentation for HANA certification provided (C_HANAIMP_10)
Guiding Resume Preparation & Tracking Interviews..