AggregationStorage Element (ASSL)


Applies To: SQL Server 2016 Preview

Identifies the storage method for aggregations.


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

The value of this element is limited to one of the following strings:

RegularAggregation data is stored in the default manner.
MolapOnlyAggregation data is stored using multidimensional OLAP (MOLAP) storage only.

The MolapOnly option is available only for the Partition element.

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

Properties (ASSL)

Community Additions