SAP HANA



HANA ( High Performance Analytic Appliance)
Is the Latest and Powerful In-Memory Database Product Introduce by SAP in late 2011 , and is the real Hotcake in the present SAP market.As HANA is an ETL (Extraction Transformation And Loading) tool, It is necessary for the developer to understand different SAP & Non SAP Sources of Extraction and Different reporting Technologies to Generate reports for Analysis purpose.
HANA Consultants are the Highest Paid ones in the market and has a Huge Demand, We are proud for being one among the very few Institutes worldwide who are well equipped and Proficient in  teaching  HANA. BI-BO-HANA is the proven successful combination. Because, simply learning HANA doesn't make sense until unless you have knowledge on where to apply your HANA skills.We teach you from the fundamentals of Data-Warehousing till the most proficient level of HANA and its associated Reporting Technologies.

THE BI-BO-HANA COMBINATION

Introduction 

  • History and Fundamentals of Data-warehousing in Depth.
  • Star Schema And Extended Star Schema Techniques.
  • Clear picture on OLTP and OLAP systems.

SAP ABAP

  • Introduction to SAP-ABAP
  • ABAP programming Basics & Fundamentals of DDIC
  • Understanding the ABAP Function modules and BAPIs
  • Creating RFC Destinations & Remote Function Calls

SAP BW

  • Introduction to SAP BW 
  • InfoObjects 
  • Non-Cumulative Key figures
  • Navigational Attributes
  • Master data Load ( Attributes, Texts and Hierarchies)
  • InfoCubes & DSOs
  • Infosets, Multi Providers & Virtual Providers
  • Generic Extraction ( Using DB Views & Function Modules)
  • Generic Delta
  • LOC Extraction
  • Clear insight on V1,V2 & V3 Updates
  • Delta Queue Monitoring
  • Datasource Enhancement using BADI and User Exits
  • Job Scheduling In Detail & Job monitoring in ECC
  • Job Triggering Techniques
  • Process Chain Creation
  • Scheduling & Monitoring Process Chains
  • Error Handling in Process Chains
  • Compression & Aggregation
  • BEx Query Designer
  • Calculated & Restricted Key Figures
  • Formulas ,Variables & Exceptions
  • Filters and Conditions
  • BEx Analyzer & BEx Web analyzer.
  • BEx reporting In depth.
  • Roles & Authorizations

Introduction to SAP HANA

  • SAP In-Memory Strategy
  • HANA compare to BW 
  • Architecture 
  • Architecture Overview 
  • IMCE and Surroundings (In memory Computing Engine)
  • Row Store & Column Store 
  • Installation and deployment scenarios 

Navigation

  • Introduction to HANA Studio
  • HANA Administration Prospective
  • Modeler Prospective
  • System monitoring.

LT (Landscape Transformation) OR Trigger Based Replication.

  • Remote Function Calls
  • Creating RFC Destinations in SAP ABAP
  • Replicating SAP tables from OLTP Server using Trigger based Replication
  • Real time Replication
  • Job Scheduling and monitoring.
  • Parallel and Multi-Thread processing.

SQL Scripts

  • Data Types
  • Table Creation, Modification, Updating and Deletion operations.
  • SQL Select Statements
  • Joins and Unions 
  • String Operations
  • Stored procedures
  • CE (Calculation Engine) Functions.
  • Aggregations and lot more.

Modelling

  • Applying star schema technique in SAP HANA
  • Attribute Views (Using Hierarchies and Joins in Attribute views in Depth)
  • Analytic Views (Using Aggregations)
  • Calculation Views
  • Using Stored procedures in Calculation Views
  • Aggregations in Calculation Views
  • Hierarchies in Calculation Views.
  • Calculation Engine Concepts in Depth.

HANA -ETL Replication Methodology

  • BODS (Business Object Data services)
  • JDBC & ODBC connectivity.
  • Replicating data from SAP OLTP Server Using BODS
  • Replicating data from Flat File Source systems
  • Replicating data from BI System
  • Backward replication technique.

Working with HANA on BI Platform

  • Data Extraction form SAP BI into Hana-Server 
  • Reporting on BI Infocubes
  • BI and BODS connectivity

Transformations using BODS 

  • Merge Transform
  • Pivot & Reverse Pivot Transformations
  • SQL Transformation
  • Key Generation Transform
  • Validation Transform
  • Case Transform

Business Objects CMC & Information Design Tool

  • Creating Repository
  • Relational Database & OLAP Connections
  • Working with Universes
  • Creation of Project & Data Foundation to Build the Universe
  • Creating Data Services Repository User

Xcelsius / SAP BO Dashboards

  • Consuming BEx Query
  • Consuming an Universe to Design a Dashboard
  • Working With TABs
  • Working with Workbook
  • Visualizing the data in Charts
  • Using Selectors

SAP HANA Reporting Using MS Excel

  • SAP HANA MDX Provider
  • Creating ODBC Connection
  • Reporting Fundamentals
  • Using Filters and Hierarchies
  • Graphical Reporting
  • Advanced Reporting Techniques.

Reporting Using Business Object Explorer 4.0

  • Creating HANA Source Systems
  • Managing Info-Spaces
  • Geographical Reporting
  • Time based reporting
  • Hierarchical Reporting
  • Configuring & Indexing the Views
  • Creating Exploration Viewset
  • Creating URLs for Web-based Reporting
  • Reporting with BOEx in Depth

Crystal Reports with SAP HANA

  • Creating Relational Database Connection
  • Reporting on HANA tables
  • Reporting on HANA Views
  • Reporting on Stored Procedures

SAP BW ON HANA

  • End – To –End implementation Scenario
  • Introduction to SAP HANA DXC (Direct Extractor Connection)
  • HANA as a Source System Via DB connect
  • Concept of HANA optimized DSOs
  • HANA optimized InfoCubes
  • Migrating DSOs & Info Cubes to HDB
  • Authorizations
  • Backup and Recovery 

SAP ABAP on HANA

  • End – To – End  Implementation Scenario
  • The ADBC connection
  • Creating External Views on HANA
  • Working & consuming  Stored procedures on ABAP
  • SAP ABAP for HANA
  • Creating Interfaces and & Proxy Classes to Communicate with SPs
  • Optimizing ABAP reports Using HANA (Live Scenario)

Software Development on SAP HANA

  • SAP HANA XS engine
  • Deploying Java Script based Application on HANA
  • SAP HANA with Odata Services
  • SAP HANA UI5 based Development

HANA Administration

  • Creating Users
  • Assigning Roles 
  • Authorizations
  • Backup and Recovery