cancel
Showing results for 
Search instead for 
Did you mean: 

InfoSet Outer Join between two ODS: Sales Line Item and Billing Item

Former Member
0 Kudos

Hi BI/BW experts,

We have a issue with infoSet with left outer join. Currently I have two ODS:

A. Sales Order Line Item ODS

B. Billing Line Item ODS

The A. Sales Item is left outer joined with B. Billing Item by sales order item number and line item number.

Assume that:

A I have Sales Order number 100, 200, and 300.

B Sales order 300, 400.

According to what the concept of the A left outer join B, I should get sales order 100, 200, and 300 related information from sales order ODS and 300 related information from billing ODS. Infact I didn't get any records at all, and the query tell me no records. I found out that even I use left outer join, it actually did inner join.

Any experts have ideas?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hallo,

i am not really an expert but i built an InfoSet with two ODS and an Outer Join and it works perfect. Are the key fields for the join ok. Not mayba 0300 on the left and 300 on the rigt? Just check the join with right mouse and than you see it and also control the staging data in the two ODS must there be an result?

Good LUCK

Santra