Skip to Content

Left Outer join in a Infoset

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 07, 2011 at 05:18 PM

    Hi

    Create infoset between infoobject and infocube and apply left outer join on the infocube and now u will output which are not present in the infocube like

    CUST01

    CUST02

    CUST06

    u won't get any data that are present in the infocube . I think no need to apply any condition . Once try it , u can get it simply

    Hope u got it,

    Thanx & Regards,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2011 at 05:15 PM

    Marcelo u2013 you should try subquery where not exists.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.