Fusion Applications OTBI: How To Configure And Use Audit For Usage and Performance In OTBI For Fusion SaaS Cloud Customers (Doc ID 2731495.1)

Last updated on JANUARY 27, 2022

Applies to:

Details

Starting with Fusion Applications Release 20D, two new subject areas are provided to monitor OTBI usage and performance:

• OTBI Usage Real Time: Monitors OTBI usage, including user, analysis and dashboard, and subject area usage trends.
• OTBI Performance Real Time: Monitors usage trends and OTBI analysis execution time, execution errors, and database physical SQL execution statistics.
• Captures OTBI Query execution data including ad-hoc queries, saved analyses and dashboards
• Six months of OTBI execution data is available in 20D.
• Data older than six months is purged weekly.
• Subject areas are secured by duty roles. There’s no data security.
• Does not contain BI Catalog change audit data.  This feature is planned for a future release.

For more detailed information, please refer to the What's New Documentation

Actions

Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports.

For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).

Tips And Considerations

OTBI usage subject areas capture each OTBI query execution and related database SQL execution details for six months. 

To ensure better performance, add proper filters to ensure optimal reporting performance.

Key Resources

A sample OTBI Usage Dashboard that demonstrates how to use the two new subject areas is attached to this document.

Attached are two catalog files containing sample dashboard, analysis and filters to demonstrate the new subject areas. 

1. Download the 2 catalog files.
2. Read and follow the steps to unarchive the files to the catalog.
3. Edit "OTBI Usage Dashboard"
4. Traced the relevant analysis section within Dashboard
5. Edit relevant OTBI analysis
6. Select relevant column and go to column properties
7. Go to Interaction tab and edit Action link
8. Browse the relevant Analysis/dashboard

Contacts

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.