Usage Tracking

Description

Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In Oracle Fusion Data Intelligence you can track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that you can use in a variety of ways such as reports optimization, user session strategies, or plan usage by users, and departments based on the resources that they consume. When reviewing the business metrics, it is important to keep the usability considerations in mind including trends, slice-and-dice, and drilldowns. Where applicable, benchmark information showcasing performance with the peer group is available. Companies typically set strategic quarterly goals in terms of key metrics; where applicable, the business metrics show progress towards such goals.

This subject area includes details of logical queries that provide insights on the types of queries generated and their performance. Along with it, the Common - Usage Tracking - Physical Query subject area provides details of physical queries sent to the database. These details can help you understand query execution plans in Autonomous Data Warehouse to identify areas of improvement in report creation. Both subject areas have the Logical query folder with a common set of attributes, that you can use to join a logical or semantic query to its physical database queries. Together, they provide valuable insights to track performance of the Oracle Analytics platform and help you design reports and visualizations that can perform optimally. This subject area provides you the ability to understand the usage and performance of logical and physical queries generated by the Oracle Fusion Data Intelligence semantic model, including customer created extensions. You can use the usage tracking data to analyze query performance and to understand the patterns of physical queries that are sent to the database and the execution plans that are generated in autonomous data warehouse. You can view the details of the physical queries generated for each logical query and their performance metrics such as row counts and time elapsed. This information is especially relevant in these scenarios:
  • While creating new custom content adhering to the recommended practices.
  • When you want to provide additional data points for the prebuilt reports while reporting performance problems and want to add metrics such as row counts, compilation time, and response times.

Business Questions

This subject area can answer the following business questions:

  • What are the average queries ran by the user by month?
  • How many number of user sessions were created per month?
  • How many distinct queries were run per month?
  • How many distinct users used the system?
  • How many distinct users used the system in a week?
  • What are the average queries ran by the user in a week?
  • How many logical queries ran by the top users?
  • What are the top 10 logical and physical queries by execution time?
  • Which dashboards and visualizations are the slowest performing?

Duty Roles

The Usage Tracking Analysis Duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Folder: /Shared Folders/Common/Usage Tracking

Workbook: Usage Tracking

Special Considerations

None.