How to use New OTBI USAGE AND PERFORMANCE SUBJECT AREAS in Oracle Fusion

In this video, We will be able to learn how to use new OTBI usage and Monitor their Performance.

The OTBI Usage Real Time subject area answers the following business questions:

How many users run OTBI analyses?
Who are the top N OTBI users?
How many analyses and dashboards have users run in the past month?
What is the weekly analysis usage trend?
What are the top N most frequently run OTBI analyses?
How many predefined OTBI analyses have been run in the past month?
How many custom OTBI analyses have been run in the past month?
How many ad-hoc OTBI analyses have been run in the past month?
What’s the execution history of a given dashboard in the past month?
Which analyses had low usage in the past three months?
How many OTBI SOAP web services have been run in the past month?
What is the SOAP API data load?

The OTBI Performance Real-Time subject area answers the following business questions:

What are the long-running analyses in the past month?
What is the OTBI execution time histogram for the past month?
Which analyses have the longest response time?
Which analyses have a high row counted?
Which analyses reached the OTBI maximum row limit?
What are the common execution errors in the past month?
How many analyses and dashboards failed in the past month?
What are the most commonly used subject areas?
What are the least used subject areas?
Which subject areas have slow performance?
Which analyses have low usage because of poor performance?
How many database SQLs are executed by an analysis?
What are the database SQL execution time and row count?

The OTBI usage subject areas are provisioned for two job roles:

IT Security Manager and
Application Implementation Consultant.

For Download Sample Dashboard Click on the Following Link


https://drive.google.com/drive/folder...