22nd November 2019 - 15th March 2020

18th November 2019

SAP BW on HANA – Dataflow and BusinessObjects Analysis

The course introduces SAP’s market leading Data Warehousing solution SAP NetWeaver BW 7.5 on HANA.

As a first step, the theoretical basics of the SAP BW on HANA system are introduced. Connected to this theoretical introduction, the acquired knowledge is applied practically to a living SAP system by solving case studies. The case studies are performed in an SAP education system. The used IDES (Internet Demonstration and Evaluation System) represents a fully developed model enterprise. It is based on the standard SAP ERP system and offers the corporate structure and the data basis to accomplish extensive analyses in the SAP BW system.
The participants learn how to work with the SAP BW-on-HANA system using the user interfaces SAP GUI and SAP HANA Studio. 

The course consists of two parts: In the first part, the basic setup of SAP BW on HANA is introduced. Following this step, the data- and information structure in the BW system are illustrated and with the help of that, students are asked to independently work on a model scenario. One emphasis in this part is the modeling of dataflows within the BW-system (ETL-Process) and data acquisition from SAP source systems. Every chapter offers theoretical knowledge about a certain part of the BW system. The BW objects that are looked upon are then being introduced and illustrated. In addition to that, the native modeling capabilities of SAP HANA are introduced. The acquired knowledge is engrossed by working on case studies. Thus, students not only gather a profound overview on setup and functionality of the BW system and its integration with the SAP ERP system (or operative systems of third-party providers). They also gain respective practical experience in working with the software. 

The second part of the course focuses on the analysis of data. First, the basics of creating reports (queries) using characteristics, key figures, hierarchies, and variables are presented and explained. Based on the data and structures that were generated by the course participants in the first part of the course, own reports and analyzes are created in the BW system. Additionally, students will perform analyzes in Excel-based SAP BusinessObjects Analysis. 

Learning Targets

After the course, students possess profound theoretical knowledge of the SAP BW on HANA system, its technical aspects and the setup of the underlying data model, as well as approaches to define analyses and reports.
Course participants, in the end, are capable to orient themselves in an SAP BW on HANA system. They will have acquired knowledge and skills in the following areas:
  • Basics and Architecture of SAP HANA and SAP BW on HANA
  • Data Models and Data Structures in SAP BW on HANA
  • Data Acquisition and Dataflow in SAP BW on HANA
  • Administration of SAP BW on HANA
  • Native Modeling in SAP HANA
  • Query Design in SAP BW on HANA
  • SAP BusinessObjects Analysis (Excel- and OLAP-Client)
Students learn to work with different functional components of the SAP BW on HANA system and its integration into complex business scenarios by first getting to know the relevant theory which in a second step is practically applied to the system. Thus, students understand the functions of the SAP BW on HANA system in a way that enables them to quickly work their ways into the specific environment of a foreign SAP BW on HANA system.


  • Part I: SAP BW on HANA – Enterprise Data Warehousing
    • Basics of SAP HANA and SAP BW on HANA
    • Data Models in SAP BW on HANA (InfoObjects, InfoProvider)
    • Data Acquisition from SAP Source Systems
    • Dataflows in SAP BW on HANA (Extraktion, Transformation, Loading)
    • Administration of Data Targets (InfoProvider Administration, Process Chains, Delta Merge)
    • Native Modeling in SAP HANA (Information Views)
    • Open ODS Views
  • Part II: SAP BW on HANA – Query Design and Analysis
    • Introduction to BEx Query Designer
    • Navigation in Queries
    • Key Figures
    • Characteristics
    • Structures
    • Hierarchies
    • Variables
    • Exceptions and Conditions
    • Reprot-to-Report-Interface
    • Administration of Query Objects
    • Query Performance Optimization
    • SAP BusinessObjects Analysis (Excel- and OLAP-Client)

SAP Certification Exam

After successfully completing the course, students are handed out the certificate of the Brandenburg University of Applied Sciences.

The official SAP certification in SAP BW (C_TBW50H_75) presupposes the contents of the following consecutive courses:

After completing these three courses, you can take the SAP certification exam at these locations.

Important information in brief

  • Total workload: The course requires a workload of 150 - 180 hours / 6 ECTS
  • Language: English
  • System requirements: 
    • Microsoft Windows (Mac users need a Windows installation on Virtual Machine: free trial versions of VM software is available on the website of various vendors)
    • Recommended: Microsoft Office
    • at least 2 GB free hardware space
    • Internet Access
  • other requirements: For participants without knowledge of SAP S/4HANA we urgently suggest the previous or parallel participation in the course Enterprise Resource Planning with SAP S/4HANA (TS410).
  • Course certificate: Certificate by Brandenburg University of Applied Sciences when all case studies are completed successfully in SAP BW during the course
  • Course fee: 585 USD


© 2019 erp4students, All rights reserved. Terms of Use | Privacy Login