OTBI Performance Real Time

Description

Analyze OTBI analysis and dashboard usage and performance, including logical and physical database SQL, execution time, and errors. View the last six months of OTBI usage and performance trends, commonly used subject areas, and report errors. This subject area provides data to monitor and diagnose OTBI reporting performance. Historical data older than six months is purged each week.

Business Questions

This subject area can answer the following business questions:

• Which analyses have low usage because of poor performance?

• Which analyses have the longest response time?

• What are the most commonly used OTBI subject areas?

• Which analyses have high data row count?

• Which analyses reached OTBI max row limit?

• What are the common execution errors in the past month?

• What are the least-used OTBI subject areas?

• How many analyses and dashboards failed in the past month?

• What is the analysis total execution time and row count?

• What are the long-running analyses in the past month?

• Which subject areas are used frequently in ad-hoc OTBI analyses?

• How many database SQLs are executed by an analysis?

• What is the database SQL execution time and row count?

• What is the OTBI execution time histogram in the past month?

Job Roles

The following job roles secure access to this subject area:

• Application Implementation Consultant

• IT Security Manager

Duty Roles

The following duty roles secure access to this subject area:

• OTBI Report Performance Transactional Analysis Duty

Primary Navigation

Not applicable

Time Reporting

This subject area supports six-month usage 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

This subject area contains six months of query execution data. Each OTBI query execution can generate multiple database SQL statements. Usage data volume grows over time, so use proper filters to narrow reporting data load. Because this subject area has no data security, you're advised to secure user access to it.