Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Alejandro
    List of reports in BIP instance
    Topic posted July 2, 2019 by Alejandro , last edited September 11, 2019, tagged Reporting, Tip 
    101 Views, 3 Comments
    Title:
    List of reports in BIP instance
    Summary:
    How to get a list of reports ordered by last used date
    Content:

    Hi, 

    We've got several instances of BIP 10g, 11g -> Planning to migrate and consolidate all reports into one single version to be defined. 

    I am trying to cleanup the catalogs and would like to see if its possible to get a list of reports, (name, datamodel, template, last usage) from the DB so I can build a meaningful list so we can make a decision about which reports are worth migrating and which ones are outdated and no longer in use. 

    Ideally I would like this to work in the 10g environments. I've got access to the host machine as well as admin access to the BIP UI. 

    Any ideas? 

    Version:
    10g

    Comment