Select Partitions to Modify (Usage-Based Optimization Wizard) (SSAS)

  • Article

Use the Select Partitions to Modify page to select the partitions for which you want to design aggregations based on usage patterns stored in the query log of the Analysis Services instance.

Note

This page appears only if the Usage-Based Optimization Wizard was started from SQL Server Management Studio.

Options

  • (Select)
    Select the check box in the column heading to design aggregations for all partitions in the measure group.

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

  • Partition Name
    Displays the name of the partition.
  • Source
    Displays the table or query used to provide source data for the partition.
  • Aggregations
    Displays a string describing the aggregation design used by the partition.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance