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

analysis report automatic refresh

Received Response
22
Views
5
Comments
933651
933651 Rank 2 - Community Beginner
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

Hi,

Is it possible to have an automatic refresh of an analysis report in OBIEE 12c while it is opened in the browser, let's say every 10 mins?

Answers

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

    You can put a piece of code like this in a text section on your dasboard page:

    <META HTTP-EQUIV = "REFRESH" CONTENT = "600"><p>Last refresh datetime: <span id="datetime"></span></p><script>var dt = new Date();document.getElementById("datetime").innerHTML = (("0"+dt.getDate()).slice(-2)) +"-"+ (("0"+(dt.getMonth()+1)).slice(-2)) +"-"+ (dt.getFullYear()) +" "+ (("0"+dt.getHours()).slice(-2)) +":"+ (("0"+dt.getMinutes()).slice(-2));</script>

    Where 600 means 600 seconds eg 10 minutes.

  • 933651
    933651 Rank 2 - Community Beginner

    It looks like it is not refreshing the data, because if I click the refresh link on the analysis immediately after the automatic refresh time, I get a different set of records.

    So looks like the automatic refresh is not really refreshing the records.

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

    You may be hitting cache.

    To avoid hitting cache you can try the following:

    In  the Advanced tab of your analysis find  the 'Bypass Oracle BI Presentation Services Cache' check box and check it

    Put the following in prefix:

    SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

    Make sure you click Apply SQL and save the report

  • 933651
    933651 Rank 2 - Community Beginner

    It is working, thanks! Can you please help me understand what are doing the modifications you mention above for the cache?

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

    These modifications make the report to ignore both BI server and Presentation server cache thus forcing the report to always retrieve new data from the database.

    To learn more about OBIEE and cache you can read the following documentation:

    https://docs.oracle.com/middleware/1221/biee/BIESG/querycaching.htm#BIESG226

    https://docs.oracle.com/middleware/1221/biee/BIEMG/variables.htm#BIEMG3867 (for the use of session variables like the ones mentioned above)