Set Aggregation Options (Aggregation Design Wizard) (SSAS)

Use the Set Aggregation Options page to start the aggregation design process, and specify storage or performance limits for the generated aggregations.

Options

  • Estimated storage reaches
    Limit the aggregation design by indicating the maximum number of megabytes (MB) or gigabytes (GB) that can be used to generate the aggregations.
  • Performance gain reaches
    Limit the aggregation design by indicating the maximum percentage of estimated performance gain that the aggregation design can provided.
  • I click Stop
    Limit the aggregation design by clicking Stop during the design process.
  • Do not design aggregations (0%)
    Specify that the aggregation design contains no aggregations. Use this option to clear an existing aggregation design for a partition, measure group, or cube.
  • Start
    Starts the aggregation design process.
  • Stop
    Ends the aggregation design process.
  • Reset
    Resets all the aggregation options on this page to their default values.

See Also

Reference

Aggregation Design Wizard F1 Help (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance