Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Default value in dynamic prompt
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 !
Answers
-
Hi,
to get rid of the nulls, try putting the 'choice list' or 'radio button' list SQL as
select your_column from yourmodel where 1=1 and your_column is not null
Try setting a default figure for your presentation variable like
where your_column = @{VAR_COIL}{98725}
0 -
By the way you misspelled Gandalf's sindarin name ;-)
0 -
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...
0 -
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
0 -
Awesome it's good to know that I'm not the only one in here weird enough to notice
0
