Skip to Content
avatar image
Former Member

Full outer join in Webi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 18, 2010 at 12:37 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

      Thank You!!

      Sent from iPhone

  • avatar image
    Former Member
    Oct 18, 2010 at 11:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2010 at 11:40 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yep Grace.

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

      Thank You!!

      Sent from iPhone

  • avatar image
    Former Member
    Oct 18, 2010 at 11:55 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 18, 2010 at 12:19 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Oct 18, 2010 at 12:30 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2010 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded