SAP S/4HANA Embedded Analytics together with SAP Business Warehouse powered by SAP HANA (SAP BW on HANA) provides the best-of-breed suite of analytical services and enables you to drive your business in real-time on the next generation of platform, SAP HANA.
Whether you need, consolidated, de-normalized reporting on data collected from several SAP / non-SAP applications and for data governance OR
real-time reporting on data from one single SAP S/4HANA component.
Whether you need, aggregated reporting or on historical data, that might not be online in the underlying SAP Business System OR
bringing reporting within SAP S/4HANA to the next level.
Analytics services provided on the SAP HANA platform will meet and exceed your requirements:
Now let us have a closer look at the data perspective!
When a BW system is running on an SAP HANA database, the BW data is stored in a special schema known as the BW-managed schema and is exposed via InfoProviders (e.g. DataStore Objects, InfoObjects, etc.).
In other (remote) SAP HANA schemas, data can be stored in SAP HANA tables and accessed via HANA views which are based e.g. on Core Data Services (CDS) technology.
You can make data available from any SAP HANA database schema of your choice in BW. You can also make BW data (data from the BW-managed schema in the SAP HANA database) available in a different SAP HANA schema. To do so you can use virtual access methods such as Open ODS Views (using HANA Smart Data Access for remote scenarios) and data replication methods like SAP LT Replication Server.
In this blog we focus on integrating data from the SAP S/4HANA Analytics schema with corresponding data in BW using the example of ERP – Sales & Distribution. And with that we will answer the following core questions:
- Will SAP S/4HANA Analytics support all my reporting requirements?
- How can I align this with my EDW strategy and (e.g. non-SAP) data?
Overview of Scenarios:
Scenario A (HANA Smart Data Access & Modeling via Open ODS):
Transactional and master data via S/4HANA Analytics consumed by BW
(Consumption of SAP S/4HANA Analytics transactional and master data views by Open ODS Views in BW)
Scenario B (Modeling-free only in embedded case):
Transactional data provisioning via S/4HANA Analytics Open CDS View in BEx Query
(Consumption of SAP S/4HANA Analytics Open CDS views in BW via ODP Transient Provider)
Other possible scenarios:
Loading of data into BW using Interface Layer of S/4HANA Analytics as data source (Extract data from S/4HANA Analytics interface views into BW)
The following guide gives an overview of different SAP S/4HANA Embedded Analytics & SAP BW Data Integration scenarios and shows how to implement them. The focus is on integrating data provided by SAP S/4HANA Analytics with corresponding data in SAP BW using the example of ERP – Sales & Distribution: