Skip to Content
avatar image
Former Member

Composition Provider (HCPR) union and left outer join question

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers