Analysis Services
Review Results (Usage-Based Optimization Wizard)
In this step of the wizard, you can view the queries that match the options you have specified for optimization of your cube partition. A status bar near the bottom of the screen displays the number of matching queries found. These results will be used to optimize future queries by modifying existing aggregations.
Options
Request Data Set Description
View information on the data requested by each matching query.
Times Executed
View the number of times each matching query had been sent to the cube.
Average Duration (min:sec)
View the average duration of each matching query.