How can I find all reports using the same BI Publisher Data Model

Sarah Munro 12024679

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

Nathan CCC

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

https://cloudcustomerconnect.oracle.com/files/caf0decefa/R13_19D_Financials_OTBI_database_mapping_with_ViewObjects.xlsx

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?

 

 

Aman Jain-Oracle

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

Veronica Dumitriu

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

Sarah Munro 12024679

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

Sarah Munro 12024679

Any updated timescales for this?

Ian Rumble

Hi Veronica,

Has this tool or functionality been delivered? We are interested in this facility

Kind regards

Ian

Arghyo Banerjee -Oracle

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

 

 

Frank Davidson

Is there a targeted SaaS release, when this will be delivered?

User_XPZIW

HI,

Do we have any updates on this?

Gaurav Bharadwaj-Oracle

@User_XPZIW and @Sarah Munro 12024679 No there is no targeted release for this yet, i would recommend that you log an Idea for this and ensure that all your colleagues in the industry upvote that idea to indicate its importance to our Product Management.

Idea Labs can be found Here :

Welcome to Cloud Customer Connect

Before creating an Idea, it is recommended to go through the Guidelines :
https://cloudcustomerconnect.oracle.com/pages/35fcc3b659

After logging in to the customer connect portal, please click on Idea menu and select the appropriate product.
On the following page you should be able to see a button "Submit Your Idea" please use that to request an Enhancement.

If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

Regards,

Gaurav