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 difference between the start time and the end time. The same results are returned from the following function:

        ROUND((CAST(END_TS as DATE)-CAST(START_TS as DATE))*86400)

• COMPILE_TIME_SEC: The time (in seconds) required to compile the query...