Best Approach: Merging Data From BW Infoprovider and HANA view
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.