Extra Pages

▼

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.

at

12 comments:

  1. stijngabrielsJanuary 28, 2009 at 8:57 PM

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

    Cheers,
    Stijn

    ReplyDelete
  2. John MinkjanJanuary 28, 2009 at 10:08 PM

    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

    ReplyDelete
  3. stijngabrielsJanuary 29, 2009 at 11:07 AM

    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

    ReplyDelete
  4. John MinkjanJanuary 29, 2009 at 12:20 PM

    Hi Stijn,

    Good tip! I will update text!

    Regards John

    ReplyDelete
  5. AnonymousFebruary 12, 2009 at 7:37 PM

    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

    ReplyDelete
  6. John MinkjanFebruary 13, 2009 at 8:00 AM

    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

    ReplyDelete
  7. AnonymousFebruary 13, 2009 at 9:32 PM

    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

    ReplyDelete
  8. people miningDecember 11, 2009 at 3:23 PM

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

    ReplyDelete
  9. John MinkjanDecember 17, 2009 at 9:56 AM

    @Master,

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


    regards

    ReplyDelete
  10. AshMay 22, 2010 at 9:17 AM

    Wonderful !!
    Worked smoothly ..

    Ash

    ReplyDelete
  11. BDSJune 11, 2010 at 12:13 PM

    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

    ReplyDelete
  12. John MinkjanJune 17, 2010 at 7:44 AM

    @BDS,

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

    regards

    John

    ReplyDelete

Note: Only a member of this blog may post a comment.