20th November 2020 - 19th March 2021

 16th November 2020

SAP BW/4HANA – Dataflow and BusinessObjects Reporting

The course introduces SAP’s market leading Data Warehousing solution SAP BW/4HANA.

As a first step, the theoretical basics of the SAP BW/4HANA 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. 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/4HANA system using the user interfaces SAP GUI and SAP HANA Studio.  The course consists of two parts:

  1. In the first part, the basic setup of SAP BW/4HANA 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.
  2. 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 as well as work with the Reporting Tools SAP BusinessObjects Web Intelligence and Crystal Reports Enterprise Edition. 

Learning Targets

After the course, students possess profound theoretical knowledge of the SAP BW/4HANA 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/4HANA system. They will have acquired knowledge and skills in the following areas:

  • Basics and Architecture of SAP HANA and SAP BW/4HANA
  • Data Models and Data Structures in SAP BW/4HANA
  • Data Acquisition and Dataflow in SAP BW/4HANA
  • Administration of SAP BW/4HANA
  • Native Modeling in SAP HANA
  • Query Design in SAP BW/4HANA
  • SAP BusinessObjects Analysis (Excel- and OLAP-Client)
  • SAP BusinessObjects Web Intelligence
  • SAP BusinessObjects Crystal Reports Enterprise Edition

Students learn to work with different functional components of the SAP BW/4HANA 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/4HANA system in a way that enables them to quickly work their ways into the specific environment of a foreign SAP BW/4HANA system.

 

Structure

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

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/4HANA (C_BW4HANA_20) presupposes the contents of the following consecutive courses:

  • SAP BW/4HANA – Dataflow and BusinessObjects Reporting
  • SAP BW/4HANA – Data Modeling and BusinessObjects Lumira (will start in Spring Term 2021)


Important information in brief

  • Total workload: The course requires a workload of 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: 450 €

REGISTER NOW

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