1
votes

I've recently been using the Oracle Catalog Manager to create lineage reports to determine which analyses use particular columns. I haven't found a way, however, to determine which reports are used on particular dashboards. So if I wanted to delete a report, is there a way to determine which dashboards would be affected?

I know that when I migrate a dashboard page from the development environment to the test environment that the structure is preserved, so this information must be saved somewhere. However, when I try to create a report in the "_portal" folder that contains the dashboards, the report is always blank.

I was using this page as an initial reference, but it only discusses how to find the reports that would be affected should a column be deleted from the rpd.

Part of what I'm trying to do is a clean-up to locate reports that aren't being used on any dashboards, but I also want to be able to better track which reports are being used and on which dashboards.

2

2 Answers

3
votes

The Create Report function will build a report of Dashboard/Analysis relationships.

enter image description here

enter image description here

Regarding moving/copying dashboards, it will not move all the dependent objects automatically - you will need to structure your Presentation Catalog such that you can migrate folders of objects as required.

1
votes

OBIEE Catalog Manager Report lacks the ability to extract data as

  • Dashboard,
  • Dashboard Page,
  • Dashboard Prompt,
  • Analysis

in a single row of data

We can have two combinations

  1. Dashboard, Dashboard Page OR
  2. Dashboard, Dashboard Prompt, Analysis

The OBIEE usage table does store the 4 fields in a single row.