Skip to Content
0
Dec 07, 2011 at 04:32 PM

Left Outer join in a Infoset

46 Views

Hi, I have the following situation;

0CUSTOMER Master data:

CUST01

CUST02

CUST03

CUST04

CUST05

CUST06

Then I have my sales cube like this:

CUST03, Quantity 10,00

CUST04, Quantity 15,00

CUST05, Quantity 40,00

So, what I need in my query is: What are the Customer that are not in my [Sales Cube]

Then I created an Infoset with 0CUSTOMER Left outer Join [Sales Cube], connection done by using 0CUSTOMER

I expected to see the following results

CUST01,NULL

CUST02,NULL

CUST03, Quantity 10,00

CUST04, Quantity 15,00

CUST05, Quantity 40,00

CUST06,NULL

Then, using a condition I could get the records I need (CUST01, CUST02 AND CUST06). But, I'm not getting this, actually, records from master data 0CUSTOMER where I dont have in the cube, I can't see in the query.

Very strange... Do you have any tip guys ?

Thanks

Marcelo