Refresh the Oracle Business Intelligence Enterprise Edition Dashboards

To view the updated data lineage information in the Data Lineage Dashboard, purge the Oracle Business Intelligence Enterprise Edition cache by following the instructions below:

1. Log in to the Oracle Business Intelligence Analytics page. For example: http://obixxx.mycompany.com:9704/analytics
2. Go to Administration.
3. In the Session Management section, select Manage Sessions.
4. Click Close All Cursors.
5. Go to Administration.
6. In the Maintenance and Troubleshooting section, select Issue SQL.
7. In the Issue SQL screen, type the following command in the text box:

   Call sapurgeallcache()

8. Click Issue SQL.
9. After purging the cache, the following success message is displayed.

   [59118] Operation SAPurgeAllCache succeeded!

Now, the custom reports will be visible in the Data Lineage Dashboard.