CompositeProvider / Multiprovider modeling questions
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?