Report Usage

Question

I've been tasked with establishing a report catalog for my company that shows reports used by the company and organized by functional area. I first need to identify reports that have been recently used and are used frequently. How can I retrieve this report meta data? Thank you.

Nathan CCC · Answer

Hi,

For a list of all out of the box prebuilt analytics and reports by application use

https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html

To get usage of analysis, prompts, dashboards in OTBI (blue) - but NOT reports in OTBI (orange)

you can use "OTBI Usage Real Time"

https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-9574337B-2A9C-4A00-AFA6-01CB5F209E96.htm

To get usage tracking of reports in OTBI (orange) - but NOT analysis, prompts, dashboards in OTBI (blue)

you need to use AuditViewDB

https://www.oracle.com/technetwork/middleware/bi-publisher/wp-fusionbipaudit-5459609.pdf

Shankar-Oracle · Answer

Please check "OTBI Usage Real Time" subject area.

You have facts like Report Count, Report Execution Count and User Count. Also, Report name, path, subject area, custom report or not etc. details available in the above subject area. Please also check the time dimension for time related columns.