Webi report changed join type

[Former Member]

I've received complaints from my users saying that their Universe is using left outer join, as they created a webi report against that universe....when they view the SQL in the Webi report, it changed the left outer join to right outer join...therefore, it gave inaccurate data ouput.....Can someone help me with this issue? Thank you very much for your time and help.

[Former Member · Accepted solution]

Hi Brian, you need to check on the universe to make sure you are NOT setting up right-outer join accidentally. If you are not implementing the outer-join parameter on the universe but instead using only the + sign, it is very easy to put it on the wrong side.

This thread belongs to the Universe forum and therefore, I am moving it.

-

---

If you are using the SAP BusinessObjects tool, you should join [ASUG|www.asug.com]

[Former Member]

Why is the data inaccurate?

Left outer join will take all records from the left table and only the records from the right table which match with the key data in the left table.