Best Approach: Merging Data From BW Infoprovider and HANA view

[former_member235973]

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.

[Former Member]

Alston,

Were you able to figure out which is the optimal solution for your scenario?  We have similar requirements currently and we are on HEC.

Option 2 would be my preference.

Thanks,

Raj