LastUpdated (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 LastUpdated property of the Dimension interface is not used by Microsoft® SQL Server™ 2000 Analysis Services. You can set this to any date/time value you want. For example, you can use it to indicate when the source data was last changed.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
Date
Access
Access depends on the value of the ClassType property of the object.
Class type |
Access |
|---|---|
clsDatabaseDimension |
R/W |
clsCubeDimension |
R |
clsPartitionDimension |
R |
clsAggregationDimension |
R |
Remarks
The LastUpdated property is not automatically set by any Decision Support Objects (DSO) method. It is provided as a means for client applications to indicate a date or time that can assist in validating information. For example, a date of 12/31/96 may mean that the information stored in a cube is not valid after December of 1996.
Example
Use the following code to update an out-of-date dimension:
'Assume an object (dsoDim) of ClassType clsDatabaseDimension exists.
If dsoDim.LastUpdated < date Then
'Insert ode to update dimension.
End If