Jaa


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

See Also

Reference

Dimension Interface
LastProcessed (Dimension Interface)

Help and Information

Getting SQL Server 2005 Assistance