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