Report as Filter with 2 column combination

Question

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

SonPat99 · Answer

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.

AA83 · Answer

Experts...Any inputs pls