O'Reilly logo

Oracle Business Intelligence Enterprise Edition 12c - second Edition by Haroun Khan, Christian Screen, Adrian Ward

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing usage

Now that we are getting data into the tables and have set up the BI repository to access the data, we can start creating analyses to see what is going on. Typical analyses that I would create are:

  • Top 10 slowest dashboards
  • Top 10 slowest analyses
  • User activity over time
  • Non-users
  • Dashboard usage analysis
  • Error reports

Usage measures

Before using some of the measures, you need to understand what each one does and how they are relevant. The following describes each field in the main usage tracking table:

  • TOTAL_TIME_SEC: The time (in seconds) that the Oracle BI Server spent working on the query while the client waited for responses to its query requests. This setting is the same as the response time in the NQQuery.log file. Usually it is the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required