Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OR condition with Date Parameter in OBIEE

Received Response
1
Views
1
Comments
1474403
1474403 Rank 1 - Community Starter
edited Aug 13, 2024 5:57PM in Oracle Analytics Forum

Hi,

I have a requirement to bring records where ship date is NULL along the date range parameter passed in OBIEE 11g Analysis.

Trying to put two filters with OR (e.g. SHIP DATE is NULL OR SHIP DATE is prompted)  this is bringing only records where date is populated not those where Date is NULL

Thanks in advance,

Regards,

Mukesh

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What kind of query is generated?

    Did you protect the filter with the OR is NULL ?

    The best thing is really to look at the generated query to see what happened and you probably easily find out you forgot a piece somewhere ...