AggregationUsage Element (ASSL)


Applies To: SQL Server 2016 Preview

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


Data type and lengthString (enumeration)
Default valueDefault
Cardinality0-1: Optional element that can occur once and only once.
Parent elementCubeAttribute
Child elementsNone

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

FullEvery aggregation for the cube must include this attribute.
NoneNo aggregation for the cube should include this attribute.
UnrestrictedNo restrictions are placed on the Aggregation Designer.
DefaultThe 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.

Cube Element (ASSL)
Properties (ASSL)

Community Additions