Full outer join in Webi

[Former Member]

How can I create a full outer join in webi? Thanks.

[Former Member · Accepted solution]

Hi BOCP-BOE, my mistake, I can set the full outer join after i changed the parameter ANSI92, thanks a lot for your help.

[Former Member · Accepted solution]

Oh Cool...!! You known good one correct. can you make it solved, Grace...!!

Thank You!!

Sent from iPhone

[Former Member]

Hi,

If data source is SAP can we combine two queries using combined query option? why it is disabled in WEBI if datasource is SAP?

Regards,

Sonal

[Former Member]

We are using oracle 10g, how can achive this? Write the "FULL OUTER JOIN" in the expression in universe?

[Former Member]

Tried ANSI92, not work.

Then I change the expression from Tab1.col1()=Tab2.col1 to Tab1.col1()=Tab2.col1(). However, when I open the join dialog box, it automatically change back to Tab1.col1()=Tab2.col1.

Universe not allow full outer join?

[Former Member]

What is the Oracle version?? After 9i onwards we have choice.

Full outer join syntax from Oracle 9i onwards

SELECT c.course_name, c.period, e.student_name

FROM course c FULL OUTER JOIN enrollment e

ON c.course_name = e.course_name

AND c.period = e.period;

Alternatives:

1. @Universe: Create Derived Table(s)

2. @ Query: Use Combined queries with UNION operator.

Thank You!!

Sent from iPhone

[Former Member]

I can't select both, when I select the left one, the right one will automatically change to uncheck. Same as the right one.

[Former Member]

Okay fine.

In Universe parameters tab, Change ANSI 92 parameter to "Yes" and try.

OR

After selecting Left or Right, in below screen you can see,

Tab1.col1*=Tab2.col1 or Tab1.col1(+)=Tab2.col1

Now change/add the operator on both sides and Parse/OK.

Hope now you can.

Thank You!!

Sent from iPhone

[Former Member]

Datasource is Oracle and I would like to create the full outer join in universe level, is it possible?

[Former Member]

Yep Grace.

While joining tables, you can see Outer Join both sides(Left & Right), Select the both.

Thank You!!

Sent from iPhone

[Former Member]

In WebI??

>> What is the datasource?? (DBMS, SAP etc..,)

See,

You can do it(FOJ) at:

1. Universe level (while joining tables).

2. Using Custom SQL @ Query panel.

Then you can see the data in WebI for FOJ.

Thank You!!

Sent from iPhone