This topic has not yet been rated - Rate this topic

DesignAggregations Element (XMLA)

SQL Server 2012

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


<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.

Concepts

Commands (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD