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
