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

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

Received Response
352
Views
3
Comments
Ramus
Ramus Rank 2 - Community Beginner
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • Ramus
    Ramus Rank 2 - Community Beginner

    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
    Gianni Ceresa Mod

    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