Default dashboard prompt

655355

How can I get the YEAR to default in the dashboard prompt to CURRENT YEAR?

What settings to I need to change to accomplish this?

Thanks

14728

There are several ways to do this.

You can setup a session variable in the Physical model that has an initialization block which does something along the lines of SELECT to_char(SYSDATE,'YYYY') from dual (Oracle).

Or you can define it for the prompt itself - when you define the prompt you can set the default based on SQL and the function YEAR(Current_Date).