Export (0) Print
Expand All
Expand Minimize

AggregationType Enumeration

Contains an enumeration of the different types of possible aggregations used only in ROLAP cubes.

Namespace:  Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

public enum AggregationType

Member nameDescription
IndexedViewCreates an indexed view for the ROLAP aggregation. The server recreates the view every time that the partition is reprocessed.
NoteNote

This option only applies to Data Sources that use SQL Server 2000 and SQL Server 2005.

TableReserved for future use.
UserDefinedThe user has defined the aggregation table for current partition.

New:   17 July 2006

AggregationType enumeration is used to define the type of aggregation in ROLAP cubes.

IndexedView only applies to Data Sources that use SQL Server 2000 and SQL Server 2005.

Defining an AggregationType to be UserDefined requires manually specifying the bindings for each granularity attribute in the aggregation to the columns in the user-defined table; there is no graphical interface to help in this process.

Community Additions

ADD
Show:
© 2014 Microsoft