AggregationUsage (Dimension Interface)

Hinweis:
Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein.

The AggregationUsage property of the Dimension interface specifies how aggregations are to be designed for the dimension levels.

Applies To:clsCubeDimension, clsPartitionDimension

Data Type

DimensionAggUsageTypes

Access

Access depends on the value of the ClassType property of the object.

Class type	Access
clsCubeDimension	R/W
clsPartitionDimension	R

Hinweise

When aggregations are designed for a dimension, the value of this property determines which levels of a dimension may have aggregations created for them. The following table describes how the value of this property affects the consideration of levels for aggregation.

Aggregation usage	Description
dimAggUsageCustom	Aggregations are created only for those levels whose EnableAggregations property is set to True.
dimAggUsageDetailsOnly	Aggregations are created only for the lowest level in the dimension.
dimAggUsageStandard	All levels are considered by the aggregation design algorithm.
dimAggUsageTopOnly	Aggregations are created only for the top (All) level.
dimAggUsageTopAndDetailsOnly	Aggregations are created only for the top (All) and lowest levels in the dimension.

Hinweis:
For virtual dimensions, AggregationUsage is read-only and automatically set to dimAggUsageStandard. An error is raised if you attempt to set this property on a virtual dimension.

Beispiel

The following example changes the aggregation behavior of the Product dimension for the Sales cube in the FoodMart 2000 database to create aggregations only for the topmost level, and then it updates and reprocesses the Sales cube:

    Dim dsoServer As New DSO.Server
    Dim dsoDB As DSO.MDStore
    Dim dsoCube As DSO.MDStore
    Dim dsoDim As DSO.Dimension
        
    ' Connect to local Analysis server.
    dsoServer.Connect "LocalHost"
    
    ' Open FoodMart 2000 database.
    Set dsoDB = dsoServer.MDStores("FoodMart 2000")

    ' Open the Sales cube.
    Set dsoCube = dsoDB.MDStores("Sales")
    
    ' Open the Product dimension in the Sales cube.
    Set dsoDim = dsoCube.Dimensions("Product")
    
    ' Set the dimension to create aggregations only
    ' for the topmost (or All) level.
    dsoDim.AggregationUsage = dimAggUsageTopOnly
    
    ' Update the cube.
    dsoCube.Update
    
    ' Process the cube.
    dsoCube.Process processFull
        
    ' Clean up.
    Set dsoDim = Nothing
    Set dsoCube = Nothing
    Set dsoDB = Nothing
    dsoServer.CloseServer
    Set dsoServer = Nothing

Siehe auch

Verweis

Dimension Interface
EnableAggregations (Level Interface)

Hilfe und Informationen

Informationsquellen für SQL Server 2005