Full outer join

[azazeererer]

Hello,

I am working with sap Bo 4.2 sp7. I would like to know how to use "Full outer join" in Universe Designe Tool?

Thanks in advance.

Regards

[mhmohammed · Accepted solution]

Hi Meryem,

Yes, for that you'll have to make sure that the ANSI92 = Yes is added in the parameters, as shown in this link.

http://www.dagira.com/2010/08/17/handling-conditions-on-outer-joins/

Then you'll be able to check Outer join on both sides like the below image (which is the Full Outer Join), you don't have to write (+) in the join condition. Plz check page 94 in this link.

https://help.sap.com/doc/464bef1d6e041014910aba7db0e91070/4.2.4/en-US/sbo42sp4_universe_design_tool_...

Thanks,
Mahboob Mohammed

[azazeererer · Accepted solution]

It works very well. thank you very much for your help 🙂

[azazeererer]

Hello,

After i changed the parameter as follows: ANSI92 = Yes. the several "Left joins" existing in the universe have been deleted. how should I do to keep the "Left join" in the universe even after changing the parameter ANSI92 = Yes?

Thanks in advance.

Regards

[mhmohammed]

Hi Meryem,

That shouldn't happen, but now, you need to make sure that the Outer Join (on one side) is checked, it will not show (+) any more, but it will still be an outer join, don't worry about that. With ANSI92, if you check the SQL, the outer join doesn't show up as Table1.column1 (+) = Table2.column1, instead it will show up as select .... from Table1 left join Table 2 on (Table1.column1 = Table2.column1). Makes sense? Check some videos on youtube for difference in SQL with / without ANSI92.

Thanks,
Mahboob Mohammed

[mhmohammed]

Hi Meryem,

Check this out to create Outer join in UDT. But if you won't be able to check Outer joins on both of tables if the ANSI92 is not turned on in the Parameters. So, you'll have to add ANSI92 to parameters as shown in the 2nd link. Let us know if this helps!

https://www.youtube.com/watch?v=rv_NlvEGxXc

http://www.dagira.com/2010/08/17/handling-conditions-on-outer-joins/

Thanks,
Mahboob Mohammed

[azazeererer]

the outer join work well in Bo :

But i want to know how to do "FULL outer join" and not "outer join" 🙂 ==> in want traduct this requete on Univers Designe Tool :

Select * From Table A
FULL OUTER JOIN Table B
ON A.key = B.key

Thanks in advance