Left outer join using infocube and inobject in infoset

[syed_er1]

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

[syed_er1]

Thanks for all your replies

syed

[Former Member]

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

[former_member223744]

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.