Review the Queries that will be Optimized (Usage-Based Optimization Wizard)

Use the Review the Queries that will be Optimized page to display and select the queries, retrieved from the query log, which will be used by the Usage-Based Optimization Wizard to design aggregations for the selected partitions.

Options

• (Select)
  Select the check box of the query that you want to design aggregations for.

• Client Request
  Displays the members referenced by the displayed query.

• Occurrences
  Displays the number of occurrences for the displayed query in the query log.

• Average Duration
  Displays the average duration for all occurrences of the displayed query.

See Also

Reference

Usage-Based Optimization Wizard F1 Help

Analysis Services Wizards (Multidimensional Data)