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.

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.

 

Thanks

Jethin Abraham

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s