Modeling with composite providers in BW 7.4
I have a modeling question regarding the use of Composite Providers in the new BW 7.4 landscape. In our Project we have three ADSOs, so we wanted to use join the two of them via use of a Composite Provider and then do a Union with the thrird one with the use of another Composite, which would be used as the last layer for reporting.
However a join Composite Provider cannot be reused under another Composite Provider, as it seems. So how would you recommend to model the above requirement?
Thx a lot,
Harish Kumar replied
Assume that you have three ADSOs A, B and C and you want the following Operation:
( A join B ) union C
This can be interpreted as ( A union C ) join ( B union C).
So, you create two composite providers of union type for A-C and B-C.
Then combine these union CPs in another CP with join condition.
This should give the same result as ( A join B ) union C.