Process (Dimension Interface)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The Process method of the Dimension interface creates and populates a dimension on the Analysis server.
Applies To:clsDatabaseDimension
Syntax
object.Process(ByVal Options As ProcessTypes)
Remarks
- object
The Dimension object to process.
- Options
One of the valid ProcessTypes enumeration constants. For more information, see ProcessTypes.
Remarks
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. |
Example
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