My boss has told me to write "I am stupid, Please help me"

[DRZ400S]

Afternoon,
Can anyone help me with this problem, I haven't been using BO for long and I've come across this problem.

I've 2 tables, If the Cell appears in table one and two everything's fine, the record is displayed. If it only appears in table one I get the no data to fetch but I want to display the record, is there anyway round this and I'll post a pint to the first correct answer!

e.g. EVENT.CALL EVENT2.CALL
1234 1234
e.g. EVENT.CALL EVENT2.CALL
123 If 123 does not exist in event 2 then no records are displayed.

Cheers Phil.

PS Am i being thick?

 

[pabloj]

This is an outer join, modify your universe join to include all rows from the other table (so to have results even if there is no correspondence there).

Stick to your guns

 

[blom0344]

Swithing to an outer join may be the direct solution for the problem at hand, but such a universe modification MAY have far-reaching consequences for other reports and in general performance. I have seen tenfold degrading of query performance in switching to an outerjoin in this way.

Workaround may be to use a second DP to get listing of non-matched records.

No, your are not thick , but do a bit of testing .....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[mohit119]

I think i understand ur problem.

Try to insert new table for second table using the 'Build new query from the universe currently in use '

Build new query anduse it in the table 2.

This will surely solve ur problem

Mohit Garg
mohit.garg@india.birlasoft.com

 

[blom0344]

Yes, Mohit that is the same as my suggestion:

"Workaround may be to use a second DP to get listing of non-matched records."


T. Blom
Information analyst
tbl@shimano-eu.com