Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 193 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Automatically refresh data on dashboard

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.
Answers
-
Hi,
Do you have SampleApp 607? (OBIEE Samples )
There are some examples on how to reload/refresh pieces by javascript somewhere inside the SampleApp. It's done by javascript, so would match what you look for.
0 -
The bit Gianni mentions is in Dashboard "9.10 Custom Interaction" -> "Other Interactions" -> "Auto Refresh"
0 -
Take a look at this:
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
0 -
Thank you very much! it`s great solutions and it`s work for me!
0