Skip to Content

Left outer join using infocube and inobject in infoset

Hello All,

I am trying to build an infoset for which i have infocube on left and infobject on right, i need to do a left outer join ( which is like i want all records of infocube no matter if that join condition has a record in inobject or not ) . I tried right clicking on the link on infocube cube side but there is no option of left outer join, but when i do the same on info object i can see and i think that will be an left outer join from info object to infocube, but i want reverse. In a nutshel what i am trying to achieve is all records in infocube should be seen in query with the couple of field values from infoobjects, if say for example if i dont have that record info object for that key, in that case also i want to see that infocube record.

Thanks

Syed

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 19, 2008 at 09:13 PM

    Hi Sied.

    Please check the note 1238583.

    For performance reasons is not possible to perform a left outer join with infocubes.

    You need to think another model to construct this scenario and get this information.

    Thanks,

    Walter Oliveira.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2008 at 06:05 AM

    Hi Syed,

    I request you to please check the beloe note :

    577953 - InfoSets (BW): Left outer joins

    Please see the documentation (help file) at the following link:

    >datawarehousing >Modelling >infoproviders >Infosets >Defining

    join conditions >Left Outer Join.

    OR

    "http://help.sap.com/saphelp_nw70/helpdata/en/67/7e4b3eaf72561ee-

    10000000a114084/frameset.htm"

    Detailed explanation about left outer join is given in the above note.

    Hope this helps you to solve the issues you face.

    Regards

    Rajesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 20, 2008 at 06:12 PM

    Thanks for all your replies

    syed

    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.