OBIEE Catalog Manager - Determine which DASHBOARDS utilize particular reports
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.
Answer
The Create Report function will build a report of Dashboard/Analysis relationships.
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.