Report of Objects in BI Catalog Folders

Rich Merkel

Summary

Is there a way to produce a report of folder structure along with objects/types that exist in the folder

Content

Hi,

Is there a way to create a report or if one is available that shows the folder structure and contents of objects and type within the BI catalog?

Thanks

Version

Oracle Financials Cloud

Rajasekhar Bandaru-Oracle

Take a copy of catalog using Archive option and   open the catalog using catalog manager in any noncloud environment and generate the report using create report option.

 

 

Rich Merkel

Thanks for your reply, is there anyway to do this in only cloud environment?  Unfortunately I don't have access to any noncloud environment.

I'm hoping for an easy way to just export the folder/subfolder names in Shared Folders along with what files/object exist in each folder/subfolder.

Arghyo Banerjee -Oracle

Kindly use the the below table to get most of the required data

GL_FRC_REPORTS_B

Hope this helps

Riyaz Ali-Oracle

Please try the below:

1.Using BI Publisher Catalog Reports

Oracle BI Publisher allows you to manage and report on catalog objects, including folders, reports, data models, and templates.
You can navigate to the BI Publisher Catalog and export details about the objects stored within it.

1. Custom SQL Query in Oracle Analytics
2. OTBI Folder ManagementOTBI allows administrators to manage folders and set permissions.
   You can create a structured report by navigating to the OTBI Catalog and organizing content accordingly.