OTBI Report Performance Transactional Analysis Duty

Code Name

FBI_REPORT_PERFORMANCE_TRANSACTION_ANALYSIS_DUTY

Job Roles

This duty role is related to the following job roles:

• Application Implementation Consultant

• IT Security Manager

Subject Areas

This duty role secures access to the following subject areas:

• OTBI Performance Real Time

Business Questions

This duty role secures access to data that 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?