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.
Default to Current Date
SELECT TIMESTAMPADD(SQL_TSI_DAY,0,CURRENT_DATE) FROM “Subject Area”
Say you want to default it to the day before , all you need to do is
SELECT TIMESTAMPADD(SQL_TSI_DAY,-1,CURRENT_DATE) FROM “T2EDW – Sell Thru”
You get the point right !!
Well, thats it for this post.