Oracle Communities

Oracle Analytics and AI

Child Item

OTBI Usage Real time subject is not displaying the details of all OTBI reports/Dashboards used

Hi,

There is a requirement to built a dashboard to monitoring the OTBI Reports usage. I'm using the 'OTBI Usage Real Time' subject area for that. I need to capture usage only from the particular folder. However im trying to filter with the report path, i'm not getting the targeted folder in drop down.

Kindly let me know how to resolve this.

Find more posts tagged with

Accepted answers

Dimple-Nagesh-Support-Oracle

Hi KeerthanaBaskaran,

For OTBI, we have two new Subject Areas to track the history, performance monitoring : Please review this announcement on CCC portal :

https://community.oracle.com/customerconnect/discussion/809029/real-time-otbi-usage-performance#latest

You can use the catalog files to download :

OTBI Usage Dashboard.zipUploaded Sep 25, 202418.97 KB

Try these and let me know if that helps.

Thanks,
Dimple N

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/60475#Comment_60475

Hi @Dimple-Nagesh-Support-Oracle,

Very informative & helpful information. Much appreciated.

Thank you very much!

Cheers,

All comments

Nathan CCC

Hi, Yes that is correct. You cannot resolve it. The subject areas for usage/performance only shows you queries from analysis and prompts to subject areas in metadata repository database RPD in OTBI. It does not show you the usage of reports with data models with data sets that do not query subject areas in OTBI. For usage tracking of reports in OTBI you need to install the auditViewDB.

KeerthanaBaskaran

Hi Nathan,

Thanks for your reply. But i'm checking regarding the OTBI reports only. We have built few reports and dashboards on OTBI and those report names are listing down when i use the OTBI- Usage real time subject area. I'm looking for the solution to retrieve all the OTBI analysis/Reports that we used.

Dimple-Nagesh-Support-Oracle

Hi KeerthanaBaskaran,

For OTBI, we have two new Subject Areas to track the history, performance monitoring : Please review this announcement on CCC portal :

https://community.oracle.com/customerconnect/discussion/809029/real-time-otbi-usage-performance#latest

You can use the catalog files to download :

OTBI Usage Dashboard.zipUploaded Sep 25, 202418.97 KB

Try these and let me know if that helps.

Thanks,
Dimple N

KeerthanaBaskaran

Thanks @Dimple-Nagesh-Support-Oracle . I will check on this and reply back. Thanks for your response.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/60475#Comment_60475

Hi @Dimple-Nagesh-Support-Oracle,

Very informative & helpful information. Much appreciated.

Thank you very much!

Cheers,

Dimple-Nagesh-Support-Oracle

Dear KeerthanaBaskaran,

Hope the details shared was useful, please close the thread if the information provided have solved the problem.

Thanks,
Dimple N

KeerthanaBaskaran

Thank you @Dimple-Nagesh-Support-Oracle , @Bhaskar Konar , @Nathan CCC for your valuable time and providing response on this.