Export (0) Print
Expand All
Expand Minimize

Assign Aggregation Design Dialog Box (Analysis Services - Multidimensional Data)

Use the Assign Aggregation Design dialog box in SQL Server Management Studio to assign aggregation designs to one or more destination partitions. You can display the Assign Aggregation Design dialog box by right-clicking a partition or aggregation design in Object Explorer and selecting Assign Aggregation Design.



Aggregation designs

Select an aggregation design to assign to one or more destination partitions.

Destination partitions

Select the partitions to which to assign the aggregation design.

The following grid is used to specify destination partitions:



<check box>

Select or clear the check box in the column header to include or exclude all listed partitions as destination partitions. Select or clear a check box next to a partition to include or exclude that partition as a destination partition.


Displays the name of the partition.


Displays the source table or query for the partition.

Aggregation Design

Displays the name of the existing aggregation design for the partition.

Hide partitions with aggregation designs

Select to show only the partitions that do not have aggregation designs assigned to them.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft