How can i autorefresh data in my dashboard ?

John305

Hello , for refreshing the data in my dashboard , i always go to the refresh button  ( see picture below ) , i wanna know if there is a solution to automaticaly autorefresh the data in the execution ? Thank you

asim cholas

There are several tools , you can use for auto refreshing a webpage (eg: Refresh Monkey or Autorefresh for chrome)

Thomas Dodds

Here's an example of using a simple java-script to achieve the same:   https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis

asim cholas

using a javascript in the section will have impact for the whole system and all users. It the requirement is only for one user, it will not work.

Martin van Donselaar

Asim,

Your suggestion (If I understand correctly) will refresh the webpage which is different from an actual refresh using the refresh option:

In Obiee12c Dashboard refresh forces Obiee to requery data from the database and caching will not be used.

asim cholas

for that we can use a disable_cache_Hit in the advanced tab

Gianni Ceresa

John305 wrote:i wanna know if there is a solution to automaticaly autorefresh the data in the execution ?

What do you mean "automatically autorefresh data in the execution" ?

Start by defining what you really look for and then there are chances that one of the few things posted above will work.

Are you looking for a way to refresh the data based on a timer? So you keep the page open and it refresh from time to time? Do you have something else in mind?

Is it for a single analysis or the whole page? Is it just for you or for all the users of that page?

The more precise you are, the better the answer is ...

PS: also doesn't hurt to say which version of OBIEE you use as some answers can depend on the version.

Martin van Donselaar

The tools you suggest would still not do a actual data refresh but just a page refresh (F5)

Thomas Dodds

Are you wanting to trigger an ETL refresh from an OBIEE page?

Martin van Donselaar

No, I assume the original poster wants to refresh because the dashboard uses (near) real-time data. Otherwise I do not really see the point of an automatic refresh.

marcobalduini

Hi John,

you can just use following javascript code inside your dashboard using a text box component;

this will make the screen automatically refresh. You can also set up the timing in milliseconds.

Marco