IsValid (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 IsValid property of the Dimension interface indicates whether the structure of a dimension object is valid. A structure is valid if it is fully and correctly defined. For example, a dimension object whose data source has not been defined is not valid.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
Boolean
Access
Read-only
Remarks
Depending on the value of the ClassType property of the object, the IsValid property checks different structure elements to confirm validity, as described in the following table.
| Class type | Checks |
|---|---|
clsDatabaseDimension |
The Name and Parent properties; the database |
clsCubeDimension |
The Name and Parent properties; the source cube; the dimension and levels |
clsPartitionDimension |
The Name and Parent properties |
clsAggregationDimension |
The Name and Parent properties; the IsValid property of the parent object of ClassType clsPartitionDimension |
Example
Use the following code to determine whether the structure of a dimension object is valid:
'Assume an object (dsoDim) of ClassType clsDimension exists.
Dim bValid As Boolean
bValid = dsoDim.IsValid
If bValid Then
'Insert code to process a valid dimension.
Else
'Something is not valid - handle errors.
End If