Skip to Content
avatar image
Former Member

CompositeProvider / Multiprovider modeling questions

Hello all,

I've got some modeling questions regarding CompositeProviders.  We don't have our HANA system installed yet and I haven't been able to prototype so I thought I would present my questions here.

The scenario I have is 2 DSO's from different source systems, and I want to harmonize on common master data and union the harmonized data. 

In non-HANA BW, I would use multiple layers of DSO's with transformations to do the harmonization and then infocubes within a Multiprovider for reporting. 

However, BW 7.3 and HANA has the CompositeProvider which allows performant joins, so instead of multiple layers of DSO's I can create a join between the source DSO and the master data conversion tables.  I would need to perform 2 joins on the 2 source DSO's, and then union the data.

I had thought that I would need to create 2 Composite Providers, each with a join, and then a Multiprovider that unioned the 2 CompositeProviders.  But I'm thinking that a single CompositeProvider can handle this modeling scenario.  I have not seen anywhere that a CompositeProvider can be used in a Multiprovider, but I'm thinking this isn't necessary.

Can anyone shed some light on this?

Thanks,

Bryan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 27, 2013 at 11:47 PM

    Hi Brian,

    You have the right idea. You can use both DSOs and the Master Data in one CP. Then you can create a BW query directly on the CP. You dont need a MultiProvider.

    Please use Transaction Code RSLIMOBW to model your scenario. Which version 7.3 or 7.31 and SPS Level is your planned installation?

    Thanks,

    Rajiv

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajiv,

      Thanks for your reply. We are using SAP BW 7.4 sp8 with hana. Could you please tell us how to handle this situation in detail? Thanks very much.

      Regards,

      Jiangyuan

  • Apr 03, 2013 at 05:07 PM

    Hi Bryan,

    The following document on Composite Provider might be helpful.

    http://scn.sap.com/docs/DOC-29885

    Regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 25, 2015 at 03:56 AM

    Hi Bryan,

    We are facing the same question like yours related to historic data.

    Is there any solutions? Thanks very much

    Regards,

    Jiangyuan

    Add comment
    10|10000 characters needed characters exceeded