Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

column fx based other column filter

Received Response
1
Views
1
Comments
3592346
3592346 Rank 1 - Community Starter
edited Aug 13, 2024 5:35PM in Oracle Analytics Cloud and Server

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.