Enroll Now sap-bw-hana-training

Online TrainingOnline Training

Corporate TrainingCorporate Training

Course On DemandON Demand

SAP BW ON HANA Training  

SAP Business Warehouse or SAP BW is an enterprise data warehouse product by SAP which can integrate and transform business information from any possible source system. SAP BW using SAP HANA was the first application by SAP to run entirely on SAP HANA, and SAP BW 7.5 is the latest update in SAP BW. SAP is known for Data Warehousing worldwide and clients will gain immensely from the planning functions, query runtime, and improvements in data load seen in this product. This has highly simplified data modeling and reduced InfoProvider. Also, all data modeling is done within a new user interface which is distinct across all modeling tools.

Course Objective

After the completion of this course, Trainee will:

  • Understand latest developments, possibilities and concepts of SAP BW 7.5 on HANA
  • Gain an overview of how to migrate and use SAP BW with SAP HANA 
  • Attain the knowledge to migrate standard objects in SAP BW to HANA-optimized InfoProviders
  • Acquire the ability to understand real-time data integration and agile data modeling
  • Gain the knowledge on SAP HANA-related data provisioning methods for SAP BW 7.5
  • Learn about BW Enterprise Data Warehousing and its application
  • Understand HANA modeling and its use in application

Who should attend this Training?

This comprehensive course is meant for professionals who aspire to build a career or upgrade knowledge in SAP BW on HANA. This course is best suited for the following professionals:

  • SAP BW Practitioners
  • SAP BW Application Consultants
  • SAP Technical and Functional Consultants
  • Professionals with interest in Data Warehousing
  • Software Analysts and Mainframe professionals
  • Project Managers and Business Objects Professionals
  • Those aspiring for a career in SAP BI/BW

Introduction to SAP HANA Studio

  • Introduction to SAP HANA
  • History of SAP HANA
  • Overview of SAP HANA Studio
  • SAP HANA Technology Innovations

SAP HANA Architecture

  • SAP HANA Architecture
  • Index Server
  • Persistence Layer

Data Provision Methods

  • Overview of Data Provision Methods
  • Flat file Uploading
  • How to get multidimensional Sales Report
  • Overview of Business Objects Data Services using ETL-based approach

Accounts Payable

  • Introduction to SAP HANA Information Models
  • Analytical View for COPA Plan using Attribute views and COPA Actual
  • How to use join operators in building Calculation view
  • Methods to create Calculation view

Overview of SAP BW 7.5 on HANA 1.0

  • Overview of SAP BW 7.5 on HANA 1.0
  • Data Warehousing Workbench

Info Objects and DataStore Objects

  • Overview of InfoObjects
  • Creating Characteristics under Catalog
  • InfoObjects Characteristics and Key Figures
  • Classification of Master Data
  • Creating Characteristics
  • Overview of Key Figures and Data Flow
  • Overview of DataStore Objects
  • How to load transactional data to DataStore Objects
  • SAP HANA Optimized DSO
  • Lookups on Active data DSO

SAP HANA InfoSource and Transformations

  • Explaining Transformations Framework and Expert Routines using Scenario based example
  • Mapping One Source Field to Target Field
  • Working with Expert Routines
  • Writing Expert Routines Code in ABAP
  • Introduction to InfoSource and Execution of two transformations before executing multiple transformations
  • InfoSource as a uniform source for several targets as targets from different sources
  • Return Tables using Transformation
  • Creating Dataflow using GUI Data flow in SAP BW on HANA and BW Oracle


  • DTP and its role in loading data to InfoCube in Extraction mode
  • Real-time Data Replication from Source system to BW and Real-time HANA Optimized InfoCubes

SLT Configuration, MultiProviders and Extractions

  • Steps for performing SLT Configuration
  • Explaining the three scenarios to implement in SLT
  • Introduction to MultiProvider and Creating MultiProvider in SAP BW 7.5
  • How are MultiProviders and InfoSets similar?
  • Mixed Models
  • ECC Extractions
  • Different Extractor types
  • Steps for Data Extraction method from Non-SAP Source systems
  • ECC Extractor using Business Content Extractors for Accounts Receivable
  • Loading data for characteristics, Master data using Business Content Extractors

BW Reporting

  • Introduction to BW Reporting - BEx Reporting Suit
  • Important Business Explorer Designers
  • BEx Query Navigation Options in WebQuery
  • Creating KeyFigure at InfoProvider and query level

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services