cancel
Showing results for 
Search instead for 
Did you mean: 

Composition Provider (HCPR) union and left outer join question

former_member262074
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)