Selecting The "Refresh" Link On Dashboard Is Not Updating OBI Server Cache When Using OBIEE 12c
Last updated on JANUARY 25, 2018
Applies to:Primavera Analytics Cloud Service - Version 126.96.36.199 and later
Primavera Analytics - Version 188.8.131.52 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:
- Login to OBIEE
- Select Dashboard dropdown and pick your associated dashboard.
- On the dashboard page, select the Page Options icon (scroll wheel)
- 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:
- After the above is completed, browse to Administration > Manage Sessions
- Find the cursor associated to the user completing the above actions
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms