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:

Symptoms

ACTUAL BEHAVIOR
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.

EXPECTED BEHAVIOR
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.

STEPS
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.

BUSINESS IMPACT
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.

Changes

Cause

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