How can i autorefresh data in my dashboard ? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can i autorefresh data in my dashboard ?

Received Response
771
Views
38
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

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

pastedImage_0.png

«134

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    asim cholas Rank 6 - Analytics Lead

    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
    Martin van Donselaar Rank 6 - Analytics Lead

    Asim,

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

    pastedImage_0.png

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

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    for that we can use a disable_cache_Hit in the advanced tab

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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
    Martin van Donselaar Rank 6 - Analytics Lead

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

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

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    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
    marcobalduini Rank 4 - Community Specialist

    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

    pastedImage_3.png