Update

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

Applies To

Syntax

object.Update

object

The dimension object to update.

Remarks

Objects of ClassType clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, and clsPartitionDimension do not implement the Update method. They are automatically updated when their parent MDStore object’s Update method is called. For more information, see Interfaces. 

Example

'Assume an object (dsoDB) of ClassType clsDatabase exists

'Create Product Dimension for database

Dim dsoDim as DSO.Dimension

Set dsoDim = dsoDB.Dimensions.AddNew("Products")

'Create a datasource

Dim dsoDS As DSO.DataSource

Set dsoDS = dsoDB.DataSources.AddNew("FoodMart")

dsoDS.Name = "FoodMart"

dsoDS.ConnectionString = "Provider=MSDASQL.1;" &_

    "Persist Security Info=False;" &_

    "Data Source=FoodMart;" &_

    "Connect Timeout=15"

'Assign datasource to dimension

Set dsoDim.DataSource = dsoDS   'Dimension DataSource

dsoDim.FromClause = "product"   'Source Dimension Table

'Update the database

dsoDB.Update

See Also