22nd November 2019 - 15th March 2020

18th November 2019

SAP BW on HANA – Data Acquisition and BusinessObjects Reporting

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

This course deals primarily with data acquisition in SAP BW on HANA. The contents of the course SAP BW on HANA - Data Flow and BusinessObjects Analysis are prerequisite to this course. 

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. For SAP BusinessObjects several Reporting Tools are provided. 

The course consists of two parts: In the first part of the course the participants will deal with the different possibilities of extracting data from different source systems into the SAP BW on HANA system in order to make them available to downstream processes and analyzes.
Initially, the focus is on SAP's own source systems (for example, SAP ERP) and the interfaces provided for this purpose, SAP Service API (SAPI) and Operational Data Provisioning (ODP). The participants will create their own DataSources in the SAP source system, replicate metadata in SAP BW and extract the data to SAP BW. In addition, SAP HANA's own interfaces for data acquisition (Smart Data Integration) and real-time data acquisition will be presented. Subsequently, the focus will be on further data extraction methods and interfaces of SAP BW on HANA. Here the interfaces File, DB Connect, Universal Data Integration, Web Service and Staging BAPI are presented and used. Another aspect of data retrieval is Delta Management in SAP BW on HANA, which is explained and used for the different data acquisition methods. Finally, the Open Hub Destination – an interface that allows data to be sent from SAP BW to downstream systems – is introduced. 

The second part of the course deals with different tools of the SAP BusinessObjects product portfolio. First of all, the Information Design Tool for the creation of data universes as the basis for analyzes and reports is discussed. Afterwards, the BusinessObjects Reporting tools BI Launch Pad, Explorer, Web Intelligence and Crystal Reports are dealt with. 

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:
  • Data Acquisition from SAP Source Systems
  • Data Acquisition from non-SAP Systems
  • Delta Management
  • Real-time Data Acquisition
  • Open Hub Destination
  • SAP BusinessObjects Universe Design
  • SAP BusinessObjects Reporting
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 – Data Acquisition
    • Data Acquisition with SAP BW Service-API
    • Data Acquisition with SAP BW Operational Data Provisioning
    • SAP HANA Smart Data Integration (SDI) and System Landscape Transformation (SLT)
    • Delta Management
    • Real-Time Data Acquisition
    • File-Interface
    • DB Connect
    • Universal Data Integration
    • Web Services
    • Staging-BAPI
    • Open Hub Destination
  • Part II: SAP BW on HANA – BusinessObjects Reporting
    • SAP BusinessObjects Information Design Tool
    • SAP BusinessObjects BI LaunchPad
    • SAP BusinessObjects Explorer
    • SAP BusinessObjects WebIntelligence
    • SAP BusinessObjects Crystal Reports

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 4 GB free hardware space
    • Internet Access
  • other requirements:
    For participants without knowledge of SAP ERP we urgently suggest the previous or parallel participation in the course Enterprise Resource Planning with SAP S/4HANA (TS410).
    For participants without knowledge of SAP BW we urgently suggest the previous or parallel participation in the course SAP BW on HANA – Dataflow and BusinessObjects Analysis
  • 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