---
title: "Set Aggregation Options (Aggregation Design Wizard) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "analysis-services"
ms.topic: conceptual
f1_keywords: 
  - "sql12.asvs.storagedesignwizard.setaggregateoptions.f1"
ms.assetid: 4672d686-10c0-43f8-a53e-a16dfa840c81
author: minewiskan
ms.author: owend
manager: craigg
---
# 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.  
  
## See Also  
 [Aggregation Design Wizard F1 Help](aggregation-design-wizard-f1-help.md)   
 [Analysis Services Wizards (Multidimensional Data)](analysis-services-wizards-multidimensional-data.md)