• Article

Set Aggregation Options (Aggregation Design Wizard)

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.