Hello everybody,

I have a problem with left outer joins. here is generated physical sql code on obiee; when I put a filter on my analysis from the right side table (e_donem as below), no result is returned. But the centered table (bidb.st_olcum_noktasi) has the data.

select distinct son.on_okuyan_kurum as c1,

     son.on_id as c2,

     end.e_donem as c3,

     end.e_id as c4,

     end.e_t0_ilk_endeks as c5

from bidb.st_olcum_noktasi son

left outer join  dgpys.endeks end on son.on_id = end.e_on_id

where  son.on_id = 7088

and end.e_donem = to_date('2017-07-01' , 'YYYY-MM-DD')

Why obiee outs the filter under where condition? Is it possible to say the query like;

select distinct son.on_okuyan_kurum as c1,

     son.on_id as c2,

     end.e_donem as c3,

     end.e_id as c4,

     end.e_t0_ilk_endeks as c5

from bidb.st_olcum_noktasi son

left outer join  dgpys.endeks end on son.on_id = end.e_on_id and end.e_donem = to_date('2017-07-01' , 'YYYY-MM-DD')

where  son.on_id = 7088

Can you help me please?

Regards,

Dilek