Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Best Approach: Merging Data From BW Infoprovider and HANA view

Hi,

In our report we need to merge data from two sources, viz. SAP BW infoprovider & HANA view( View is created on HANA database of ECC server, This ECC on HANA system is used as unified OLAP/OLTP system). Please note that, BW & ECC are on different HANA instances. For reporting we are using BO tools.

We have thought of two ways to achieve this data merge:

1. Exposing HANA view in BW system via VirtualProvider based on DTP & then having a MultiProvider on both the Infoproviders (BW Infoprovider & VirtualProvider of HANA view). We will create a BEx query on top of it and use it in BO reports.

2. By Creating a MultiSource universe with the two different data sources BW infoprovider & HANA view accordingly. Then creating report using this universe as a source.

Please suggest the best approach with reasons.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question