Skip to Content

Getting an error "a table may be outer joined to at most one other table" in BO 3.1

Getting an error "a table may be outer joined to at most one other table" in BO 3.1 Web Intelligence report when made changes in universe including view created in database

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 12, 2017 at 07:43 PM

    Hi,

    Is the universe on top of Oracle DB?. Can you run the same query in WebI within Oracle?.

    check the Universe Parameter whether is NO or YES for ANSI92.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jyothirmayee,

      We have identified two outer joins from same table which is causing this error.

      I tried creating right outer join & short cut join also by creating an alias table however getting incorrect results in that situation.

      Please suggest some other solution to get rid of this error.

      Thanks,

      Gautam