Export (0) Print
Expand All
Expand Minimize

AggregationUsage Element (ASSL)

Controls how the Aggregation Designer in Microsoft SQL Server Analysis Services designs aggregations.


<CubeAttribute>
   ...
   <AggregationUsage>...</AggregationUsage>
   ...
</CubeAttribute>

Characteristic

Description

Data type and length

String (enumeration)

Default value

Default

Cardinality

0-1: Optional element that can occur once and only once.

Relationship

Element

Parent element

CubeAttribute

Child elements

None

The value of this element is limited to one of the strings in the following table.

Value

Description

Full

Every aggregation for the cube must include this attribute.

None

No aggregation for the cube should include this attribute.

Unrestricted

No restrictions are placed on the Aggregation Designer.

Default

The Aggregation Designer applies a default rule based on the type of attribute (Full for keys, Unrestricted for others).

The enumeration that corresponds to the allowed values for AggregationUsage in the Analysis Management Objects (AMO) object model is AggregationUsage.

Community Additions

ADD
Show:
© 2014 Microsoft