Oracle Analytics Cloud and Server

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

Report as Filter with 2 column combination

Received Response
1
Views
2
Comments
AA83
AA83 Rank 2 - Community Beginner

Hi All,

Need your inputs on a requirement where I need to use a analysis as filter for another analysis using two columns.

If we do this normally,  OBIEE will filter Column Col1 & Col2 of report A using  Col1 and col2 of report B putting IN clause in the report query .

But how to do this for a combination of Col1 & Col2..trying to avoid model change or the dirty solution of Concat .

Is there any other way ?

Cheers!!
A

Answers

  • AA83
    AA83 Rank 2 - Community Beginner

    Experts...Any inputs pls

  • SonPat99
    SonPat99 Rank 6 - Analytics & AI Lead

    That's the way OBIEE works...

    Why do you want to combine both columns anyway? To handle this at OBIEE Presentation Server side, you will have to concat the columns.