column fx based other column filter

Question

Hi Every One,

Below is the scenario which i need to implement in Obiee.

Query :

select c1,c2,(select c3 from t3 where t1.c1='1' and t3.c5='s' and t1.c2=t3.c2) as C3, from t1;

I need to implement in obiee. Please help us.

Thanks,

S

Gianni Ceresa · Answer

First that query is quite “bad” and my first impression is that your DB would refuse to run it ...

Based on what I guess you try to do, simply model that join between the 2 tables and done. Can even be done inside a single LTS, simple, easy and clean.

OBIEE is about modellling, the tool generate the queries, not you.