QP0005 - Outer Joins are Incoherent

[Former Member]

Hi,

I am trying to join a table twice, once with inner join and again with another table with a outer join.

When i try to create a report with objects from all 3 tables I get an error QP0005 : Outer joins are incoherent.

My db is SQL server 2005 and I am a new to this DB

Can anybody throw some light on this issue?

Thanks

David

[Former Member]

I have this fixed, both the joins and the import. Had to change the SQLSRVEN.PRM file to read this way.

LEFT_OUTER=

RIGHT_OUTER=

OUTERJOINS_GENERATION=ANSI_92

This forces the ANSI outer join syntax and also allows the universe to be imported.

Thank You!!

[Former Member]

Let me explain the scenario:

I have tables a ,b,c ,d ,e

a equi joined with b

a equi joined with c

a equi joined with d

e outer joined with a

e outer joined with c

e outer joined with d

This is the required condition.

I am trying to create a report for which field in e is not null select a measure from a.

But I get "Outer joins are incoherent error.

[Former Member]

What do your contexts look like in this universe?

[Former Member]

All of these joins are defined in a single context. since there in only one fact table out of these.

[Former Member]

Did you try changing the Properties/Parameter??

Thank You!!

[Former Member]

Hi, Yes I tried changing ANSI-92 to YES in parameters but no luck.

Have raised a case with SAP support and following it up.

Will post it if I get any fix for this.

Thanks!

[Former Member]

This message was moderated.