Default Current Date in OBIEE Dasboard Prompt

Hello All,

In most of the current dashboards users would want to default the date range to a specific interval . Defaulting the report to current date is not only a frequent ask but also helps to reduce the number of records to be processed by the BI Server therby improve performance when the report is run for the first time.

In order to default the dashboard prompt to the default date the easiest method is to select the default selection to SQL Result and paste the following code below.

Blog Stats

Click here to find me on Linkedin

Starting with Business Intelligence after graduating from college, I have developed and deep interest in Data Warehousing and its concepts. I love problem solving, challenges and learning new tools in Data Warehousing and Big Data. This website is all about my journey with different tools . Currently I have expertise in OBIEE, Informatica Power Center, ODI , MDM and intend to pursue Data Science