Skip to Content

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

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?



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