- Right-mouse on the Warehouse sample cube.
- Select Usage Analysis… from the context menu that appears, as shown in Figure 3.
Figure 3: Select Usage Analysis … from the Context Menu
The Welcome to the Usage Analysis Wizard dialog appears, as depicted in Figure 4.
Figure 4: The Welcome to the Usage Analysis Dialog
We see, within this dialog, the six pre-defined reports from which we can choose. Notice that clicking on any report title populates the Description field, beneath the selection list, with a short summary of the purpose of the report. The six reports and their descriptions are summarized in Table 1.
Report Selection
Description
Query Run-Time Table
The run time of queries, ordered from the longest to the shortest run time.
Query Frequency Table
The frequency of queries, ordered from the most to the least frequent.
Active User Table
Users and the number of queries they have enacted, ordered from the most to least queries sent per user.
Query Response Graph
A distribution of the response time for all queries.
Query By Hour Graph
The total number of queries processed, grouped together by hour.
Query By Date Graph
The total number of queries sent, grouped together by date.
Table 1: The Six Preformatted, On-Screen Reports
We will select the Query Frequency Table report for our initial walkthrough of the wizard.
- Select the Query Frequency Table report.
- Click Next.
The Select the Criteria to Filter This Report dialog appears, as shown in Figure 5.
Figure 5: The Select the Criteria to Filter This Report Dialog
Continues… - Select Usage Analysis… from the context menu that appears, as shown in Figure 3.