• Artigo

Process (Dimension Interface)

ObservaçãoObservação

  Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam.

The Process method of the Dimension interface creates and populates a dimension on the Analysis server.

Applies To:clsDatabaseDimension

Sintaxe

object.Process(ByVal Options As ProcessTypes)

Comentários

  • object
    The Dimension object to process.

  • Options
    One of the valid ProcessTypes enumeration constants. For more information, see ProcessTypes.

Comentários

The following values for Options are valid for processing a dimension.

Process type

Description

processDefault

The default option. Setting this option causes the system to default to the necessary processing option based on the changes found in the data. In most cases, the system refreshes the dimension object's data (processRefreshData). However, if the structure of the dimension has changed, or the dimension has not yet been processed, the system fully processes the dimension (processFull).

processFull

Causes the dimension object to be fully processed or rebuilt. The object's structure is changed if needed and its data is refreshed (that is, discarded and repopulated). This is the most complete type of processing supported. This operation occurs inside a transaction, allowing users to continue using current data while the transaction takes place. After the transaction is committed, the new data is available.

processRefreshData

Causes the dimension object data to be refreshed (that is, discarded and repopulated), but does not change the object's structure. This operation occurs inside a transaction, allowing users to continue using current data while the transaction takes place. After the transaction is committed, the new data is available.

Exemplo

The following example locks the Product dimension of the FoodMart 2000 database, completely reprocesses it, and then unlocks it so others can make changes:

    Dim dsoServer As New DSO.Server
    Dim dsoDB 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 Product dimension.
    Set dsoDim = dsoDB.Dimensions("Product")
    
    ' Lock the dimension for processing.
    dsoDim.LockObject olapLockProcess, "Locked for processing."
    
    ' Completely reprocess the dimension.
    dsoDim.Process processFull
    
    ' Once complete, unlock the dimension.
    dsoDim.UnlockObject
    
    ' Clean up.
    Set dsoDim = Nothing
    Set dsoDB = Nothing
    dsoServer.CloseServer
    Set dsoServer = Nothing

Consulte também

Referência

Dimension Interface