AggregationDesign Element (ASSL)

Defines a set of aggregation definitions that can be shared across multiple partitions in a database.

Syntax

<AggregationDesigns>
   <AggregationDesign>
      <ID>...</ID>
      <Name>...</Name>
            <Description>...</Description>
      <EstimatedRows>...</EstimatedRows>
      <Dimensions>...</Dimensions>
            <Aggregations>...</Aggregation>
      <EstimatedPerformanceGain>...</EstimatedPerformanceGain>
      <Annotations>...</Annotations>
   </AggregationDesign>
</AggregationDesigns>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	AggregationDesigns
Child elements	Aggregations, Annotations, Description, Dimensions, EstimatedPerformanceGain, EstimatedRows, ID, Name

Remarks

The corresponding element in the Analysis Management Objects (AMO) object model is AggregationDesign.

See Also

Reference

Partition Element (ASSL)
Aggregation Element (ASSL)
Aggregations Element (ASSL)
Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance