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.