SAP BW 7.5 Training on HANA Course


SAP BW 7.5 on HANA Training

SAP Business Warehouse is an enterprise data warehouse product by SAP. This can integrate and transform business information from the source system. SAP BW using SAP HANA was the first application by SAP to run entirely on SAP HANA. SAP is known for Data Warehousing worldwide with the services of this product clients will gain immensely from the planning functions, query runtime, and improvements in data load. SAP BW suggests that you are using HANA as a database for BW data modeling capabilities and no other database is required. Oracle, Microsoft, IBM DB2, Teradata Etc are the various databases supported by BW software.

This course in IQ online training is precisely crafted to prepare you for the SAP BW certification exam and get an in-depth understanding of SAP BW which will help you confidently work as SAP BW Consultants. Getting Certified in SAP BW on HANA will give a competitive edge over other consultants in the job market.

Instructor-Led Live Online Training Connect Live
Corporate Training Contact Us
One to One Online Training Join Demo


Course Name  SAP BW 7.5 on HANA training
Contents  Introduction, Modelling Parts, Migration, Etc.
Duration 30 Hours with Flexible timings
Delivery Instructor Led-Live Online Training
Eligibility Anyone Graduate
Ideal For Aspirants seeking to learn SAP
Availability Regular/Weekend Batches. 24×7 teaching assistance and support.
LiveOnline Training Live SAP BW 7.5 Training by Certified & Industry Expert Trainers by Providing On-Demand Server and Lab access.


Group Training

Looking training for a group (3 or more participants)?

Request for a Call Back

Course Objectives

What you’ll learn in SAP BW on HANA Training Course?

  • Understand the latest concepts, developments, possibilities of SAP BW 7.5 on HANA
  • You will  how to migrate and use SAP BW with SAP HANA 
  • You will acquire knowledge on how to migrate standard objects in SAP BW to HANA-optimized InfoProviders
  • Obtain the knowledge on SAP HANA-related data provisioning methods for SAP BW 7.5
  • You will Understand real-time data integration and agile data modeling
  • Gain Knowledge on HANA modeling and its use in an application.
  • You will learn about BW Enterprise Data Warehousing and its application

Who can go for SAP BW On HANA Training?

This course is best suited for 

  • SAP BW application consultants
  • SAP BW Practitioners
  • SAP BW Application Consultants
  • SAP Technical and Functional Consultants
  • Software Analysts
  • Mainframe professionals, 
  • Project Managers
  • Business Objects Professionals
  • Professionals with an interest in Data Warehousing
  • To obtain a career in SAP BI/BW

What are the pre-requisites to learn SAP BW 7.5 Course?

Basic BW and HANA concepts, like DataStore Objects (DSO), Data Transformations, Query optimization, InfoCubes, HANA Modeling and HANA DB feature using HANA Studio.







Course Curriculum


SAP HANA Introduction
SAP HANA System Overview
Modeling Part – I
SAP HANA Creation of views
Attribute View
Analytical View
Types of Joins in SAP HANA
Calculation View
CV with DIM & Cube & Star Join
SAP HANA View Properties (Variable, Input Parameters, Filters Etc )


Overview of SAP HANA SQL

Modelling Part – II

Transport Management

Unit 1: Getting Started with SAP BW On HANA–specific enhancements

  • Difference between BW and HANA
  • Semantic Partitioned Object (SPO) (SAP BW 7.3) with Data Flow

Unit 2: Hybrid Modeling in Mixed Scenarios

  • Mixed scenarios of SAP BW and HANA schemas
  • HANA-Optimized Data Modeling: Info Objects
  • SAP HANA optimized objects (Optimized DSO & HANA Optimized Cube )
  • Publishing of SAP HANA models to Analytical Index (Transient Provider)
  •  Importing BW models to HANA
  • Importing HANA models to BW
  • HANA Optimized ODS & Cube
  • HANA Optimized Open ODS View
  • HANA Optimized Advanced DSO
  • Composite Provider
  •  Converting BW Query to SAP HANA view
  • Designing SAP BW Query on Eclipsed based version
  • SAP BW/4HANA Modeling Tools in Eclipse(New Data Flow)

Unit 3: Modeling with SAP New Architecture LSA++

  • Layered Scalable Architecture without SAP HANA
  • Layered Scalable Architecture plus plus (LSA++) with SAP HANA
  • Open operational Data Store Layer

Unit 4: SAP BW4HANA Migration

  • Pre – Migration Activities
  • Post Migration Activities
  • Implementation Methodology

Unit 5: BW4HANAData Management

NLS – Near-line Data storage ( Cold, Warm and Hot )

Unit 6: SAP BW4HANA Data Provisioning

  • SLT Replication into SAP BW
  • Operational Data Provisioning into SAP BW
  • ODP – BW
  • ODP – SAP (Extractors)
  • ODP – SAP HANA Information View
  • ODP – SLT Queue

Future Road Map

SAP BW4HANANew Innovations

Download Material

Write Review


More reviews...


Write a Review

No review posted.