Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

List of reports in BIP instance

Received Response
83
Views
3
Comments
Alejandro
Alejandro Rank 1 - Community Starter

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

Answers

  • Dir_Pal
    Dir_Pal Rank 6 - Analytics Lead

    check 

    1: If this report is been used in application anywhere (Check that report table which would be useful)

    2: if its used check the path in application of the reports

    3: Check the check the catlog date.

    else check this link 

    https://technology.amis.nl/2016/01/31/usage-tracking-reports-using-oracle-enterprise-manager-13c-sam-tool/

  • Alejandro
    Alejandro Rank 1 - Community Starter

    Thank you - but I don't think the link applied as I am in an on premises instance + 10g. I was hoping there was some kind of SQL or if reports are stored in the file system a hint to where/what to look for. 

    Regards, 

  • Skolli-Oracle
    Skolli-Oracle Rank 4 - Community Specialist

    Please review the below doc:

    How To Generate a Server Usage Audit Report for BI Publisher Enterprise (Doc ID 1326571.1)

    For Scheduled reports, we can check from 'Report Job History"

    I recommend to check the XMLP_SCHED_JOB table for XMLP_SCHED_OUTPUT tables for both online and scheduled reports.