How to get list of all BI Reports from a folder/instance
How to get list of all BI Reports from a folder/instance

 949 total views

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.

Want to learn Fusion Technical tools? Checkout this article

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.

Click on Administration BI options fusion hcm
Click on Administration
Click on Export Captions under Manage Catalog Captions fusion hcm
Click on Export Captions under Manage Catalog Captions
Click Browse and navigate to the folder of Interest and Click OK
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 fusion hcm
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.

Selec the default "As an XML table" and click OK fusion hcm
Selec the default “As an XML table” and click OK
Output in Excel File
Output in Excel File

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

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

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.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 6 Comments

  1. Sunil Chilu

    We can also use below script….

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

  2. Sreekanth

    Nice Work

  3. Sricharan

    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

  4. Sunil Chilu

    Hi Sri,

    Thank you for more insight on the script….

  5. VG Raja

    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

  6. Sricharan

    Hi Raja,
    You cannot extract the reports at permission level as we do not have access to those tables..
    Thanks,
    Sricharan

Leave a Reply