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