Select Filter Criteria (Usage Analysis Wizard)
In this optional step of the wizard, you set criteria to analyze query usage. A query log contains information about the queries sent to your cube. To determine the specifics of your report, you apply filters to this log. Available filter criteria include time period, users, query duration, and query frequency.
This step is optional. If you select no filter criteria, the wizard will return a report on all queries. If you want to skip this step, click Next.
Options
Queries for the dates
Select to set the one week period of dates you want the wizard to analyze. To choose the start date for the week to be analyzed, ether type the date directly into the One week beginning with field, or select the expand (...) button to choose the start date. If, in the Introduction step, you selected Query by Date Graph, this check box is automatically selected.
Queries by these users
Select to add users and groups of users whose queries you want the wizard to analyze. Because the available users and groups are defined based on user roles, you cannot filter by users unless you have defined user roles. For more information about roles, see Database, Cube, and Mining Model Roles.
- Add
- Click to display the Select Users dialog box, where you can select users from the list of available users.
- Remove
- Click to remove a selected user or group from the list.
Queries that ran more than
Select to tell the wizard to analyze only queries that were sent more than a certain number of times.
Queries that took longer than
Select to tell the wizard to analyze only queries that took longer than a certain amount of time. Use the two boxes provided to specify the number of seconds or minutes.