Oracle Transactional Business Intelligence
How can I find all reports using the same BI Publisher Data Model
I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.
Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible?
Oracle BI EE 220.127.116.11.0
OBI has a web service to manage the catalog.
In the bi desktop client tool is a catalog manager that uses the web services to report on dependencies between objects.
Oracle have used this tool to extract a list of objects into a spreadsheet including the paths to the components.
This is published in the help as sheet "data lineage".
For example in financials you have "Review data lineage"
which has the following sheet
This may help you answer your question.
I assume you can unarchive the catalog to a local copy of obi 18.104.22.168.0 on your laptop then use the catalog manager to read from the catalog offline?
OBI presentation catalog related information can be easily exported to a flat-file using Catalog Manager (which comes along with the OBI Admin tool).
Below is the oracle documentation you can refer:
Hope this helps!
Currently, this functionality is not available in OTBI or BIP for Fusion. We're working on creating a BI catalog metadata export utility for SaaS and we can include BIP metadata analysis in the requirement (I assume this is what you are interested in since you mentioned the Data Models) and we'll incorporate it into future releases of the product.
I hope this helps.
Thanks for this. Yes, I want to be able to see all reports created using the same data model so I can understand the impact of making changes to a data model.
Any updated timescales for this?
Has this tool or functionality been delivered? We are interested in this facility
As part of Workaround
Different layouts can be created in a single BI Publisher Report which can accommodate different views of the data extracted from the same Data Model
Is there a targeted SaaS release, when this will be delivered?