HANA BI Developer


HANA BI Developer


HANA is used as a DATABASE to improve the performance of the reports or fasten the data access of the company's Existing Business Warehouse tool. So, for a HANA consultant, it is must to understand the reporting as well as the BW concepts. The Combination of BW, Hana & Business Objects (Reporting) will make you familiar with all the skills that you require to work independently and also the skills that any Industry look for. At the end of the course, we will be working on 2 LIVE SCENARIOS i.e. BW on HANA & ABAP on HANA to understand the system much better.

What does this course include?


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


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


  • 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


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


  • 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 BW Platform

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

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


  • 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


  • End – To – End Implementation Scenario
  • The ADBC connection
  • Creating External Views on HANA
  • Working & consuming Stored procedures on ABAP
  • 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