• Post category:BI Publisher
  • Post comments:6 Comments
  • Post last modified:June 12, 2020
  • Reading time:3 mins read
How to get list of all BI Reports from a folder/instance
How to get list of all BI Reports from a folder/instance
- How to get list of all BI Reports from a folder/instance
Total Visits: 31
Todays Visits: 0

In this article we will look into how to get the list of all reports in a folder. If we need the complete list of custom reports, then we can run this on the /Shared Folders/Custom folder.

Many times, we would need the list of custom reports in a folder and there is no easy way to get this list as we don’t have the backend tables where we can run a query against to get the complete list.

If there are some 10 integrations that you have developed and you will have to fill in the migration form now. You need to get the complete list of the report paths for data model and BI reports and then fill in manually.

There is a feature to get the list of BI Reports in XML format. Then you can either copy paste directly from XML or you can import it to Excel and then use it as per your need.

You would need BI Admin access to use this feature.

Navigate to Reports and Analytics by clicking on Tools > Reports and Analytics or directly by adding /analytics to the POD link

https://abcd-dev1.fa.us2.oraclecloud.com/analytics

Once you are on the BI Catalog page, click on the Administration link at the right top.

administration - How to get list of all BI Reports from a folder/instance
Click on Administration
export captions 1024x317 - How to get list of all BI Reports from a folder/instance
Click on Export Captions under Manage Catalog Captions
path and ok - How to get list of all BI Reports from a folder/instance
Click Browse and navigate to the folder of Interest and Click OK

I have selected /Shared Folders/Human Capital Management/Payroll Folder as I am interested in looking at all the seeded Payroll Reports.

Once you click OK, it will process and download an XML file with all details in that folder.

The XML file can be opened in IE or Notepad and it looks like:

export xml 1024x515 - How to get list of all BI Reports from a folder/instance
Export XML

You can open this XML file in Excel for importing it as XML Table.

In Excel, File > Open > Browse and navigate to the XML path and select the XML file and click OK.

xmltable - How to get list of all BI Reports from a folder/instance
Selec the default “As an XML table” and click OK
output in excel 1024x331 - How to get list of all BI Reports from a folder/instance
Output in Excel File

This is how we will export the list of BI Reports in a specific folder

Tip: We can use this approach to get the list of reports. Very useful in cases where we need the complete list of reports that were built for a client or when we want to check for seeded reports for a module.

  • We can also use below script….

    select * from FUSION_ORA_ESS.REQUEST_PROPERTY_VIEW where
    1=1
    AND UPPER(NAME) LIKE ‘REPORT_URL’

  • Hi Sunil,

    The SQL query that you sent will not pull all reports but only the ones which have been scheduled and ran earlier. The approach mentioned in this article will list the complete list of reports and data models in a folder.

    Thanks,
    Sricharan

  • Hi Sricharan,

    This is Raja The above given query is very useful to get the list of folders under /shared/custom

    Like this is there a query to get list of permissions assigned for folders and subfolders

    Thanks
    Raja

  • In visible box by plugintheme