The course deals with SAP’s market leading Data Warehousing solution SAP BW/4HANA.
This course deals primarily with data acquisition and data modeling in SAP BW/4HANA. As a first step, the theoretical basics of the data acquisition and data modeling in SAP BW/4HANA are introduced in full detail. 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/4HANA system using the user interfaces SAP GUI and SAP HANA Studio. In the area of application design, you will use SAP BusinessObjects Lumira to create own analytical applications.
The course consists of three parts:
- In the first part of thecourse, you will deal with the various options for extracting data from different source systems into the SAP BW/4HANA system to make this data available to downstream processes and analyzes. Initially, the focus is on SAP's own source systems (e.g. SAP ERP) and the operational data provisioning (ODP) interfaces provided for this purpose. You will create your own DataSources in the SAP source system, replicate metadata in SAP BW and extract the data into SAP BW. In addition, the SAP HANA interfaces for data acquisition (Smart Data Integration, File) and real-time data acquisition will be presented. Then the focus will be on further data extraction methods and interfaces of the SAP BW/4HANA system. The file interface and other ODP contexts (SLT, ABAP CDS Views) and the embedded BW in SAP S/4HANA are presented and used here. Another aspect of data acquisition is delta management in SAP BW/4HANA, which is explained and used for the various data acquisition methods.
- In the second part of the course, the participants deal with SAP's own enterprise data warehousing architecture for the implementation of SAP BW systems and projects: the LSA++ (Layered Scalable Architecture). Based on this, important aspects of SAP BW projects are explained and a logical as well as BW model is created for an integrated scenario. Thereafter, the participants will deal with the Physical Modeling in SAP BW/4HANA. The previously developed logical models are transferred to InfoObjects, InfoProviders and Information Views. The focus here is on the optimal design of the data models to meet a given requirement.
-
In the third part of the course participants will build Analytical Applications on top of the previously created data models using the SAP BusinessObjects tool Lumira. Furthermore, Data Mining and Analysis capabilities of SAP BW are examined using HANA Analytical Processes.
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:
- Data Acquisition from SAP Source Systems
- Data Acquisition in SAP HANA (File, Smart Data Integration, Local HANA DB Schema)
- Embedded BW in SAP S/4HANA
- ODP Contexts (SLT, ABAP CDS Views, ODP-type Information Views)
- File Interface
- Delta Management
- Real-Time Data Acquisition and Data Streaming
- Basics of Data Modeling
- Layered Scalable Architecture++
- SAP BW Projects and Logical Modeling
- Physical Modeling in SAP BW/4HANA and SAP HANA
- SAP HANA Analytical Process
- SAP BusinessObjects Lumira
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 – Data Acquisition
- Data Acquisition with SAP BW Operational Data Provisioning
- SAP HANA File Interface
- SAP HANA Smart Data Integration (SDI)
- Embedded BW in SAP S/4HANA
- Further ODP Contexts (ABAP-CDS, System Landscape Transformation, ODP-type Information Views)
- File Interface
- Delta Management
- Real-Time Data Acquisition and Data Streaming
- Part II: SAP BW/4HANA – Projects and Modeling
- Basics of Data Modeling
- Layered Scalable Architecture++
- SAP BW Projects
- Logical Model
- BW Model
- BI Content
- Physical Modeling in SAP BW/4HANA
- Physical Modeling in SAP HANA
- Mixed Scenarios in SAP BW/4HANA
Part III: SAP BW/4HANA – Application Design - SAP HANA Analytical Process
- SAP BusinessObjects Lumira
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 presupposes the contents of the following consecutive courses:
Important information in brief
Note: You need to participate in both BW/4HANA courses to be permitted for the SAP Exam.