General OBIEE

Get Involved. Join the Conversation.

Topic

    Sarah Munro
    How can I find all reports using the same BI Publisher Data...
    Topic posted November 14, 2019 by Sarah MunroRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models, Public Sector 
    37 Views, 4 Comments
    Title:
    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

    Comment

     

    • nathan morgan (at Client)

      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

      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

        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