Refresh the Oracle Analytics Server Dashboards

To view the updated data lineage information in the Data Lineage Dashboard, purge the Oracle Analytics Server cache by following the instructions below:

  1. Log in to the Oracle Analytics 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.