Default value in dynamic prompt

Question

Hi everybody !

I've got a prompt for my dashboard like this :

For each "Coil number", i can have different Dates. So i did set up my "Date DEF" column like this to dynamically get the associated dates :

Here are my 2 questions :

I don't want the "NULL" value to show up. How can i achieve that ?

I want to select  the max date by default. I tried to achieve this by defining a presentation variable on my "Coil Number" and using it in my SQL request as you can see in the second screenshot. But i doesn't work. I'm out of ideas... How can i get this done?

Thanks !

[Deleted User] · Answer

Awesome it's good to know that I'm not the only one in here weird enough to notice

Mithandir · Answer

Thanks for your answers !

About the NULL values, Gianni Ceresa's comment did the trick, i just had to remove the "nullable" option in the physical layer, thanks !

But i still can't get the default value to be the max date. Setting a default value for the presentation variable didn't help...

PS : Yep Christian, you're not the first one noticing but it's an old mistake so i just kept it that way

Gianni Ceresa · Answer

Hi,

Is "Dim Four"."Date DEF" physical column (the one mapped in the BMM) set as nullable? If it is by default OBIEE will add the NULL as the column is defined as nullable...