Oracle Analytics Cloud and Server

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

Automatically refresh data on dashboard

Received Response
508
Views
4
Comments
Rank 2 - Community Beginner

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

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.

  • Rank 2 - Community Beginner

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

  • Rank 5 - Community Champion

    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

  • Rank 2 - Community Beginner

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

Welcome!

It looks like you're new here. Sign in or register to get started.