OTBI Performance Real Time

Description

Provides real-time information on OTBI analysis and dashboard usage, logical and database SQLs, execution time and errors. From this subject area, report developers and administrators gain insight into OTBI usage and performance trend, commonly-used subject areas and report errors. This subject area provides data to monitor and disagnose OTBI reporting performance. This subject area contains six-month OTBI execution data.

Business Questions

This subject area can answer the following business questions:

• What are the long-running analyses (greater than 3 min)? What is the trend by month, by week, by day, by hour?

• What is the report total execution time?

Job Roles

The following job roles secure access to this subject area:

• Human Resource Analyst

Duty Roles

The following duty roles secure access to this subject area:

• OTBI Report Performance Transactional Analysis Duty

Primary Navigation

Not available

Time Reporting

The subject area can be used to report on history data.

Time dimension is linked to "Time"."Report Start Date".

Transactional Grain

This subject area returns data at the grain of a query execution and database physical SQL.

Special Considerations

OTBI report execution data has been accumulated since Fusion 18.02 update. Each OTBI query execution may generate multiple database SQLs. Customers must understand the growth of OTBI usage data volume over time and use proper filters to narrow usage reporting data load. This subject area has no data security. Customers are advised to secure user access to this subject area.