Usage Analysis Wizard - Introduction
The Usage Analysis wizard helps you set criteria to analyze the queries sent to your cube. You can choose from a variety of reports to analyze:
- Query run time
- Frequency of queries
- Users and the queries they have sent
- Distribution of query response time
- Total number of queries processed by hour or by date
Select one of these six reports to display query usage analysis on-screen:
- Query Run-Time Table: A table showing the run time of queries, ordered from the longest to the shortest run time.
- Query Frequency Table: A table showing the frequency of queries, ordered from the most to the least frequent.
- Active User Table: A table showing users and the number of queries they have sent. Queries are ordered from the most to least queries sent per user.
- Query Response Graph: A bar graph showing the response time for all queries.
- Query By Hour Graph: A bar graph showing the total number of queries processed, grouped by hour.
- Query By Date Graph: A bar graph showing the total number of queries sent, grouped by date.
Options
Next
Choose this option to go to the next step of the wizard.
Cancel
Choose this option to cancel the completion of the wizard and return to the OLAP Manager.
Help
Choose this option to view this Help topic.
(c) 1988-1998 Microsoft Corporation. All Rights Reserved.