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

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

Options

  • (Select)
    Select the check box in the column heading to design aggregations for all displayed queries.

    Select the check box for a query to design aggregations for just the selected query.

  • 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 occurences of the displayed query.

See Also

Reference

Usage-Based Optimization Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance