How to get the list of all custom reports in OTBI

Question

Hello,

Would like to know if there is a way to get all the custom reports created in Fusion or possible there is a query to get the list?

Thanks!

Riyaz Ali-Oracle · Answer

Please check the below docs as it might be helpful:

How do you export a list of custom reports from OTBI? — Cloud Customer Connect

How To Query Details Of ALL BIP, OTBI and FRC Reports (Doc ID 2722120.1)

Nathan CCC · Answer

Hi,

Meta data of definitions of analytics and reports is not stored in database. When you create analysis or report in OTBI you create on the middleware application server a file. You do not insert a row into a table in the database.

But you can read the presentation catalog using API or you can unarchive your custom folder from your catalog to a local on-premise version of OBI for which you can report on the ctalog using CatalogManager.

Only if when you run an analysis in OTBI then a row is put in a table for usage tracking
https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-9F8FCB4B-EA17-4302-813A-BEF84F295A6A.htm#GUID-9F8FCB4B-EA17-4302-813A-BEF84F295A6A

or when you run an report in OTBI then a row is put in a table for AuditViewDB
https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/audit-data-publisher-catalog-objects1.html.

MMS · Answer

So far, I only see the option to create an analysis to check the usage, but not one to pull the number of existing reports. I am interested in this response, as well.