My Oracle Support Banner

Selecting The "Refresh" Link On Dashboard Is Not Updating OBI Server Cache When Using OBIEE 12c (Doc ID 2352581.1)

Last updated on AUGUST 19, 2020

Applies to:

Primavera Analytics Cloud Service - Version and later
Primavera Analytics - Version and later
Information in this document applies to any platform.


After executing a Primavera Analytics ETL to populate new or adjusted data into Data Warehouse, selecting the "Refresh" link on an existing dashboard within OBIEE does not dynamically add "OBIS_REFRESH_CACHE=1;" to the analysis preventing the OBIS process to execute a direct statement to the database for re-seeding the OBIS cache. This results in old/stale data from being returned in the Dashboard Analysis.

When selecting the "Refresh" link from a Dashboard Page Options, the "OBIS_REFRESH_CACHE=1;" variable should be dynamically appended to user's report execution for re-seeding the OBIS cache. This will allow for updated/new data to be returned from an existing Dashboard Analysis.

Note:  Starting with OBIEE 12c, the variable should be appended when selecting refresh to re-seed OBIS cache.

The issue can be reproduced at will with the following steps:

  1. Login to OBIEE
  2. Select Dashboard dropdown and pick your associated dashboard.
  3. On the dashboard page, select the Page Options icon (scroll wheel)
  4. Select Refresh. Note that the page does not reflect updated data

Additionally, while the above is being completed and a secondary session is connected with a user assigned to an OBIEE Administrator role:

  1. After the above is completed, browse to Administration > Manage Sessions
  2. Find the cursor associated to the user completing the above actions
  3. Note that the output does not contain the "OBIS_REFRESH_CACHE=1;" variable.

The issue has the following business impact:
Due to this issue, users cannot see new or adjusted data from their dashboards after a Primavera Analytics ETL is executed.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.