Automatically refresh data on dashboard

Question

Hi, i have obiee 12c and i want to know, how i can refresh my data without refreshing the whole page. for example: i have dashboard with few charts on it. Data in this charts can be updated every 1 minute, and i want to see data changes with out refreshing whole page, only in charts. Maybe i can make some ajax queries or maybe i can call already existing queries? it have to be like an online app. Thanks.

Егор · Answer

Thank you very much! it`s great solutions and it`s work for me!

Chris Arnold · Answer

Take a look at this:

https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis?v=7516fd43adaa

We used it & it worked very well for us.

Just be sure to also bypass the presentation server cache & bi server cache within whatever reports you are trying to auto refresh.

To do that, you'll want to:

To bypass cache in a single report

----------------------------------

1)Go to Advanced tab of Report

2)Go to Advance SQL section

3)Check the 'Bypass Oracle BI Presentation Services Cache' check box

4)Go to Prefix Section

5)Write the below command:

SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

-make sure before saving click Apply SQL Query Button in the bottom

6)Save the report

[Deleted User] · Answer

The bit Gianni mentions is in Dashboard "9.10 Custom Interaction" -> "Other Interactions" -> "Auto Refresh"