Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI 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
