This course focuses on the SAP NetWeaver BW 7.3, the standard-software of SAP AG for the functional area of Data Warehousing.
The course processes a large part of the functional scope of the SAP BW-software. Besides the profound theoretical knowledge on data modeling as well as reporting and analysis in SAP BW, you will receive the opportunity to implement the acquired knowledge in working on integrated case studies. The goal of this course is the development of expertise in the range of the SAP BW-software solution. Furthermore, the participant acquires, in case of a successful participation of this course, a certificate of the University of Duisburg-Essen.
The theoretical basics gained in the course Introduction to SAP BW are inevitable for this course. They will be addressed to and enhanced by further and deeper knowledge on the SAP BW system. In the course run, students again apply the new theoretical knowledge practically to the system. This consolidates the knowledge and helps to acquire important practical skills in working with a BW system.
The course consists of four parts:
- The training scenario encompasses building a data model for the area of Controlling. Here, students are asked to implement the whole process starting from the logical data modeling to implementing the physical data models in SAP BW.
- After having defined the logical and physical models for the SAP BW implementation project, all required objects are available for the ETL process. However, one object type is still missing which students will deal with mainly in this part of the course. To run the ETL process independently from any other employee of the company own DataSources based on the BI Content DataSources need to be defined. First the ETL process for the actual cost accounting data are defined. In the next step the students load the required data into the DataStore Object and InfoCube for actual costs using a Process Chain. Afterwards the Delta Management in SAP BW is used to keep the actual costs InfoProviders uptodate.
- InfoProvider models are introduced and applied. Students will deal with MultiProvider scenarios, performance optimization using Semantically Partitioned Objects, non-persistent InfoProviders such as InfoSets and VirtualProviders as well as Real-time Data acquisition and HybridProviders.
- Students will use the afore modeled data objects and loaded data to run sophisticated reports and analyses. Therefore, students will define own queries and enhance presentation and analysis capabilities using the BEx Analyzer Design Mode. Additionally, students engage extensively with the Web Application Designer to design interactive Web Applications. Finally, it is shown how data from different sources can be combined in order to capture invisible patterns and connections. To reveal complex and hidden structures, the Analysis Process Designer and Data Mining techniques are used.
The contents of the individual chapters are structured in a way that helps students to get a broad overview over functions of the SAP BW system and internalize its handling.