Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 254 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 94 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to default the parameter initial value to the latest/max date?
Hello,
Any idea on how to default the parameter initial value to the latest or max date?
Best Answer
-
Hi @Job21 fyi. I have used the 'Time.Date' column. If you are using any other subject area to create this parameter ensure you have a filter on some metric in the query to fetch default value.
Raghu
1
Answers
-
Use Logical SQL Query option to default it to CURRENT_DATE.
1 -
@Prasad Kolli-Oracle can you give me a sample logical SQL query? Sorry I'm just new to it. And is it possible to MAX date, not current date, because there maybe some situation that current date may not be available yet. Thanks!
0 -
Yes, you can use the MAX function, derive the sample logical SQL query using Developer tool/Query Log option in OAC.
1 -
how can I go to that Developer tool/Query Log option in OAC?
0 -
Screen shot example :
1 -
It worked. Thank you @Raghavendra Raghunath-Oracle !
0
