Wednesday, January 28, 2009

OBIEE Autorefresh no prompts

Ok this trick only works if you don't have any prompts on the dashboard page. They can live on other pages if you want to keep them.

Add a text element to your dashboard

image

Enter :

<META HTTP-EQUIV = "REFRESH" CONTENT = "900">

where 900 is the refresh time in seconds. Don't forget to check the Contains HTML Markup box.

Till Next Time.

Edit: Stijn pointed me to adding:

<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE" >

To avoid caching of the browser.

12 comments:

Stijn said...

Hi John,
it's not really clear to me, why (or when) I should add this to a dashboard.

Cheers,
Stijn

John Minkjan said...

Hi Stijn,

The user requested a refresh of his OLTP based dashboard every 15 min. He has a dedicated screen only for this page.

Regards John

Stijn said...

Hi John,
in that case I advise you to add:
META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE" as well, to avoid caching of the browser. Just to be sure.

Regards,
Stijn

John Minkjan said...

Hi Stijn,

Good tip! I will update text!

Regards John

Kevin said...

Good info John,

We are currently using OBI 10.1.3.2 SE for our reporting and we have a similar requirement where the dashboard page needs to refresh at the specific interval. I have followed your steps but I dont see an option for " HTML Mark up" . Is this option available only in specific version or I am I missing some thing here .
I am logged in as an admin

Thanks
Kevin

John Minkjan said...

Hi Kevin,

I haven't worked with the SE edition but it seems strange to me that this option isn't availible. I'm using a text element from the dashboard edit controls. Which one are you using?

regards John

Kevin said...

John,

I am using the same .. text element from the dashboard editor..
Strange.. I will try to look in the bookshelf if there is anything in there..
Thanks for your reply

master.whitish said...

I don't see this option too.
Version OBI SE1 10.1.3.2.1

John Minkjan said...

@Master,

I haven't worked with the SE edition so I can't help you there.


regards

Ash said...

Wonderful !!
Worked smoothly ..

Ash

BDS said...

Hi John,

I have Dashboard Prompt and the Prompt is refreshed with updated values from the db when the page refreshes; which is great.

However, how can I stop the prompt from including its previous selection in its drop down list?

Any help much appreciated,
John also

John Minkjan said...

@BDS,

Could you please elaborate? Which previous selections do you mean?

regards

John