OBIEE Dynamic (Refresh the dashboard and change the Filter values every 5 minutes) — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE Dynamic (Refresh the dashboard and change the Filter values every 5 minutes)

Received Response
62
Views
4
Comments
User_QE77W
User_QE77W Rank 2 - Community Beginner

Hi guys,

Can anyone assist with the requirements bellow. The client wants to display this report on a screen or projector and it has to refresh in a specific intervals and the below prompts has to be updated and the report should refresh as well.

  1. We have 3 Filter parameter (Business Unit, Application Type and Channel).
  2. This report has to be refreshed at a specific interval (5 unites for example) and refresh the results.
  3. For example Filter on Scenario 1:
    1. Business Unit = ‘SME'
    2. Application Type = ’New’
    3. Channel = ‘O’
    4. Then refresh the page as usual
  4. Filter on Scenario 2:
    1. Business Unit = ‘SME'
    2. Application Type = ’Add Sim’
    3. Channel = ’T’
  5. Etc.
  6. Attached is the example image.
  7. IMG_4589.jpg

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    This is one for javascript, just search the board, questions of this nature have been asked before....

    See =>

    You just need to add the code to change your filters which should not be difficult.

  • 2709444
    2709444 Rank 3 - Community Apprentice

    Thank you Robert. I tried the below code given by @SriniVEERAVALLI in my Narrative view.

    But, my analysis wasn't getting refreshed every 5 second. Can you please suggest me? Please find the below screenshot.

    Code:

    <!DOCTYPE html>
    <html>
    <body>

    <p>A script on this page starts this clock:</p>
    <p id="demo"></p>

    <script>
    var myVar=setInterval(function(){myTimer()},5000);

    function myTimer()
    {
    var d=new Date();
    var t=d.toLocaleTimeString();
    //document.getElementById("demo").innerHTML=t;
    //setTimeout("javascript:HereLink('d:dashboard~p:i3pub16he83q7e9c~r:qqq9loggk8hvpl85','Refresh');",5000);
    //or
    //setTimeout("HereLink('d:dashboard~p:i3pub16he83q7e9c~r:qqq9loggk8hvpl85','Refresh');",5000);
    }
    </script>

    </body>
    </html>

    Screenshot:

    pastedImage_4.png

  • You need to keep in mind that this thing is a piece of code ...

    &lt; = <

    &gt; = >

    And you are also supposed  to remove the doctype, html and body elements as you are already inside a webpage.

    You maybe want to git familiar with the basics of HTML and javascript.

    Or look inside Sample App (OBIEE Samples ) which has examples of code to refresh analysis in a page based on timer etc.

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    Here is another solution for refreshing dashboards on desired intervals. You may want to give it a try:

    https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis