Process (Dimension Interface)
[!참고] 이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
The Process method of the Dimension interface creates and populates a dimension on the Analysis server.
Applies To:clsDatabaseDimension
구문
object.Process(ByVal Options As ProcessTypes)
주의
- object
The Dimension object to process.
- Options
One of the valid ProcessTypes enumeration constants. For more information, see ProcessTypes.
주의
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. |
예
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