• Article

DesignAggregations Element (XMLA)

Creates aggregations for an aggregation design on a Microsoft SQL Server Analysis Services instance.

Syntax

<Command>
   <DesignAggregations>
      <Object>...</Object>
      <Time>...</Time>
      <Steps>...</Steps>
      <Optimization>...</Optimization>
      <Storage>...</Storage>
      <Materialize>...</Materialize>
      <Queries>...</Queries>
   </DesignAggregations>
</Command>

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

Command

Child elements

Materialize, Object, Optimization, Queries, Steps, Storage, Time

Remarks

The DesignAggregations command is used to generate aggregation definitions stored by an aggregation design. An aggregation design can then be used to materialize aggregations for a partition and can be reused between partitions.

See Also

Concepts

Commands (XMLA)