Skip to Content

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

Modeling with composite providers in BW 7.4

Hello experts,

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,


Former Member
Former Member replied

Hi Giorgos,

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.

Br, Harish

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question