Skip to Content
0

Composition Provider (HCPR) union and left outer join question

Apr 06 at 10:25 AM

15

avatar image

Is there a more recent version of the SAP Composite Provider modelling guidance, other than the BW 7.4 SP5 document that Stefan produced.

Does anyone have experience of modelling a Infocube + SPO in union, followed by a DSO used as a left outer join.

A standard DSO contains three lines with Chars P1, S1, and A1.

P1, S1, A1

P2, S1, A1

P3, S1, A1

SPO contains

S1, A1, 40.00 EUR

Infocube contains

S1, A1, 25.00 EUR

The report should show

P1, S1, A1, 65.00 EUR

P2, S1, A1, 65.00 EUR

P3, S1, A1, 65.00 EUR

This works with DSO left outer join to SPO.

But not when the Infocube is union to SPO and left outer to DSO it does not.

Regards,

Lee

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers