How to create AND OR condition in obiee 11g filters.

Question

Hi All,

I have created dashboard prompt and Analysis with filters prompted. I have to use filter combination as below

For Ex:    AND   Processed Date is Prompted

OR Termination Date is Prompted

AND Current Record Ind is equal to / is in Y

Problem is, When I enter only Processed Date, condition is not applying on report. means it is displaying all values(I checked the log and in query no Processed date filter).

It is working only when i enter both values(Processed and Termination dates). Can someone help me on this please.

I need this one to work when i enter either one value or both values.  Thank in Advance!

Thanks,

Ram

Gianni Ceresa · Answer

Well ... depends on what you really try to achieve as logic and behaviour ...

As said your filter work as expected when a prompt isn't set, so the logic works fine which means you have to review the logic of what you try to achieve. And that's in your mind ... no idea what it is

Ramus · Answer

Thanks for reply Ceresa!

I tried default filters with impossible conditions but the default filter values is visible to user when he opens the report.

Is there anyother way? Thanks in advance!

Thanks,

Ram

Gianni Ceresa · Answer

Actually I will say it works as designed ....

If you do not set "Termination Date" it's like saying any value of "Termination Date" is valid. And from a logical point of view (condition on "Processed Date") OR TRUE will always return TRUE for all the rows, which make the filter useless. So it just works as it's supposed to be.

The issue, from my point of view, is how you designed the filter. Try to set real values in the filter instead of "is prompted", if you don't protect the filter OBIEE will anyway replace it with the value. So try setting default filters with conditions which are impossible, so you turn the (condition on "Processed Date") OR TRUE into (condition on "Processed Date") OR FALSE which will be simplified by just applying the "Process Date" filter.