Skip to Content
avatar image
Former Member

Universe Designer in BO 4.2 - Oracle SQL Join made by 3 tables

Hi There,

I'm using BO Universe Designer in 4.2 and I was wondering of you create a join made by three tables

Is it possible?

Many thanks

Ercole

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 14, 2016 at 02:19 PM

    Hi Ercole,

    Why don't you create 2 joins separately? A join between 2 tables (A,B) first, another join between 2 tables (B,C)?

    What's the requirement? What's the relationship between tables? What does the data look like? Some more details can help us to help you better.

    Check these out:

    http://stackoverflow.com/questions/4892267/oracle-join-3-tables-which-way-is-efficient-or-is-there-any-difference-at-all

    How to join three tables in SQL query – MySQL Example


    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2016 at 04:27 AM

    Hello Ercole,

    I would also recommend to create a view based on your requirement at the Database level and just pull that view in your Universe so as to avoid overhead of joining tables at universe level.

    If the data is on the higher side we can always go with Materialized View.

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded