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

[gautam_dholaria]

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

[jyothirmayee_s]

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

[gautam_dholaria]

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

[jyothirmayee_s]

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

[former_member526952]

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