This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions


Default dashboard prompt

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?



  • 14728
    14728 Member Posts: 633
    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).
This discussion has been closed.