OR condition with Date Parameter in OBIEE

Question

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

Gianni Ceresa · Answer

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