SAP Business Warehouse for SAP HANA (SAP BW/4HANA) is the successor of SAP BW on SAP HANA. In comparison to SAP BW on SAP HANA, developments have started from a completely different codebase.
SAP BW/4HANA can be leveraged to harmonize and structure data from multiple
sources and systems into data models. It can handle data from SAP and non-SAP feeder systems. Not all data that SAP BW/4HANA can leverage needs to be stored in the database. After the data is ready for consumption, SAP BW/4HANA allows for fast and dynamic reporting.
The general architecture of a data model is based on the Layered and Scalable Architecture ++ (LSA++) from SAP. This architecture prescribes a general way of working that consists of mandatory and optional layers. The goal is to have a flexible architecture that is both scalable and reusable to minimize the total cost of ownership (TCO). The figure below depicts this approach.
The Virtualization layer is the only mandatory layer, and, as the name states, it doesn’t persist any data in the database. It also allows access to all of the layers beneath it. The reason behind this is to maintain a flexible approach. All the data that is needed for analytical reporting is consumed through this Virtualization layer.
If anything were to happen to the underlying data model or if any of the other layers were to change or disappear, this would not impact reports built on top of the virtualization layer.
All other layers in the LSA++ architecture are optional. It’s important to note that optional doesn’t mean unnecessary; it means that any of these layers have their use and advantages in a data warehouse approach, but that you have the freedom on how to tackle each data model that has to be developed.
To use SAP GTS data for analytical reporting, you need to integrate SAP GTS with SAP BW/4HANA. The integration between SAP GTS and SAP BW/4HANA can be established as part of their standard functionality. First, set up a remote function call (RFC) connection between SAP BW/4HANA and SAP GTS. Then, enable the data transfer from SAP GTS to SAP BW/4HANA via Customizing by activating the data transfer to SAP BW/4HANA on the FTO, document type, and item category levels.
The following figure shows the integration between SAP GTS and SAP BW/4HANA. As previously mentioned, SAP BW/4HANA can leverage data from both SAP and non-SAP systems.
The objects that enable data to be available for use in SAP BW/4HANA are called data sources. Data sources can make use of different technologies to extract data or virtualize data to SAP BW/4HANA. The following are the most common methods:
In this blog post, we focus on the first method: extracting from SAP GTS to SAP BW/4HANA. Currently, this is the most efficient way to leverage data maintained in SAP GTS.
Note: The other methods (i.e., SAP HANA views and CDS views) can also play an important role, but as the provided content for SAP GTS doesn’t suit all scenarios, data extraction to the data warehouse is still highly recommended. One advantage to keep in mind is that any SAP HANA views or CDS views (i.e., that you would use or create for operational reporting) can also be used to create a data source for your data warehouse.
At a high level, data extraction from SAP GTS to SAP BW/4HANA works as follows. First, the SAP BW/4HANA system fetches the changed (i.e., delta) information from the data sources on a regular basis and combines the data from multiple SAP GTS tables to transform them into a specific format. As many SAP GTS tables contain globally unique identifiers (GUIDs) as unique keys, it’s important to review that the extractors don’t forward this information to your SAP BW/4HANA system to minimize complexity and storage costs.
After the data extraction is finalized and available in SAP BW/4HANA, the data can be transformed and enhanced based on the needed requirements for the analytics reporting. After this activity is completed, master data and transactional data is accessible in SAP BW/4HANA and allows for multidimensional analyses from various business perspectives. For example, you can access consolidated data from different modules (i.e., SAP GTS, SAP S/4HANA, etc.) via a single report.
The following sections cover more details on the extraction of data from SAP GTS.
When you’re setting up SAP BW/4HANA to integrate with SAP GTS, there are 22 standard queries with corresponding dataflows and extractors, as listed in the table below. Queries contain key figures, which are numeric values or quantities (e.g., net price or quantity) used in the output reports as objects for analysis. Queries relate to actual reports and specify what data is leveraged.
9
The strength of the SAP BW/4HANA reports lies in their customizable nature. Analysts can continuously make modifications such as adding or removing variables and inserting metrics to analyze large sets of data. This allows users to make informed business decisions.
You can apply SAP BW/4HANA content in three ways:
SAP BW/4HANA offers several advantages for reporting:
Editor’s note: This post has been adapted from a section of the book Implementing SAP Global Trade Services by Nick Moris, Pablo LeCour, and Li Yu.