How can I find all reports using the same BI Publisher Data Model
Summary
I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.
Content
Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible?
Version
Oracle BI EE 11.1.1.9.0
Comments
-
Hi,
OBI has a web service to manage the catalog.
https://host/analytics/saw.dll?wsdl
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"
https://docs.oracle.com/en/cloud/saas/financials/19d/analyze-and-report.html
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 11.1.1.9.0 on your laptop then use the catalog manager to read from the catalog offline?
0 -
Hello Sarah,
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:
https://www.oracle.com/technetwork/middleware/bi/documentation/bieqt-1911962.pdf
Hope this helps!
Best Regards,
Aman Jain
0 -
Hi Sarah,
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.
Regards,
Veronica
0 -
Hi
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.
regards
Sarah
0 -
Any updated timescales for this?
0 -
Hi Veronica,
Has this tool or functionality been delivered? We are interested in this facility
Kind regards
Ian
0 -
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
0 -
Is there a targeted SaaS release, when this will be delivered?
0
