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:
Overview of Scenarios:
Scenario A:
Transactional data provisioning via HANA Live Query View in BEx Query
(Consumption of SAP HANA Live query views in BW via ODP Transient Provider)
Demo: http://scn.sap.com/docs/DOC-58995
Scenario B:
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)
Demo: http://scn.sap.com/docs/DOC-59444
Scenario C:
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)
Demo: http://scn.sap.com/docs/DOC-61041
Scenario 😧
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)
Demo: http://scn.sap.com/docs/DOC-61042
Other possible scenarios:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |