Skip to Content
0

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

Jul 12, 2017 at 05:58 PM

53

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Jul 12, 2017 at 07:43 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Jyothirmayee,

Yes the universe is on top of Oracle DB & I tried to run same query in webi getting this error.

Tried changing Universe Parameter NO or YES for ANSI92 & getting error (+) is not permitted.

We are using complex join which includes few outer join using (+) also the query does not give correct results if we remove this outer join.

One report is working fine using the same universe however other two reports are giving this error.

Please suggest.

Thanks,

Gautam

0

Hi,

Check the SQL code and compare the results with your Oracle query executing what WebI generated.

You can get the SQL code from WebI Query Panel

Thanks,

Jothi

0

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

0