Go Hybrid – SAP HANA Live & SAP BW Data Integration!
SAP HANA Live together with SAP BW 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 Business Suite 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 ERP 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 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 SAP HANA schema, data can be stored in SAP HANA tables and accessed via HANA views. 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 and data replication methods.
In this blog we will focus on integrating data from the SAP HANA Live schema with corresponding data in BW using the example of ERP – Sales & Distribution. And with that we will also answer the following core questions:
- Will SAP HANA support all my operational, tactical, and strategic reporting requirements?
- How can I get the reporting functionality I need by combining the strengths of SAP HANA Live and SAP BW on HANA?
Overview of Scenarios:
Transactional data provisioning via HANA Live Query View in BEx Query
(Consumption of SAP HANA Live query views in BW via ODP Transient Provider)
Transactional data provisioning via HANA Live Reuse View enriched by BW master data
(Consumption of SAP HANA Live reuse views in BW adding BW master data features using Composite Provider)
BEx Query with key figures based on historical/plan BW data and most current SAP HANA Live data
(Consumption of SAP HANA Live views and BW DataStore Object by CompositeProvider in BW)
Transactional and master data via SAP HANA Live consumed by BW
(Consumption of SAP HANA Live transactional and master data views by Open ODS Views in BW)
Other possible scenarios:
- Historic BW data virtually accessed via HANA Calculation View which combines HANA Live and BW data (Custom built HANA
Calculation View combines data from HANA Live view and BW generated HANA views)
- Loading of data into BW using Reuse Layer of SAP HANA Live as data source (Extract data from HANA Live reuse views into BW)
The following guide gives an overview of the different SAP HANA Live & SAP BW data integration scenarios and shows how to implement them. The focus is on integrating data from the SAP HANA Live schema with corresponding data in BW using the example of ERP – Sales & Distribution.