Compartir a través de

  • Artículo

Update (Dimension Interface)

[!NOTA]

  Esta característica se quitará en la versión siguiente de Microsoft SQL Server. No utilice esta característica en nuevos trabajos de desarrollo y modifique lo antes posible las aplicaciones que actualmente la utilizan.

The Update method of the Dimension interface updates the definition of a dimension object in the meta data repository.

Applies To:clsDatabaseDimension

Sintaxis

object.Update

Notas

  • object
    The Dimension object to update.

Notas

Objects of ClassType clsAggregationDimension, clsCubeDimension, and clsPartitionDimension do not implement the Update method. They are automatically updated when the Update method of the parent MDStore object is called.

Ejemplo

The following example changes the Description and LastUpdated properties for the Product dimension of the FoodMart 2000 database and updates the dimension on the Analysis server:

    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")
    
    ' Change the description and update date
    ' of the dimension.
    dsoDim.Description = "Product dimension"
    dsoDim.LastUpdated = Now
    
    ' Update the dimension.
    dsoDim.Update
    
    ' Clean up.
    Set dsoDim = Nothing
    Set dsoDB = Nothing
    dsoServer.CloseServer
    Set dsoServer = Nothing