How to default the parameter initial value to the latest/max date?

JobDeLuna

Hello,

Any idea on how to default the parameter initial value to the latest or max date?

Raghavendra Raghunath-Oracle

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

Prasad -Oracle

Use Logical SQL Query option to default it to CURRENT_DATE.

JobDeLuna

@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!

Prasad -Oracle

Yes, you can use the MAX function, derive the sample logical SQL query using Developer tool/Query Log option in OAC.

JobDeLuna

how can I go to that Developer tool/Query Log option in OAC?

Prasad -Oracle

Screen shot example :

JobDeLuna

It worked. Thank you @Raghavendra Raghunath-Oracle !