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

Report as Filter with 2 column combination

Received Response
2
Views
2
Comments
AA83
AA83 Rank 2 - Community Beginner
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

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 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.