Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 29, 2015 at 05:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded