IsPredictable (clsColumn)
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 IsPredictable property of an object of ClassType clsColumn indicates whether the column's parent mining model object can predict the column's value based on other input columns.
Data Type
Boolean
Access
Read/write
Remarks
A column can have both the IsPredictable and the IsInput properties set to True.
Note
All columns are considered as input columns when training a mining model unless they are disabled. It is only when predictions are carried out against a mining model that the notions of IsInput or IsPredictable have any meaning.
The value of the IsPredictable property can be related to other properties of the object, as well as properties of the parent object. Changing the property can also affect the properties of related objects, including parent objects.
For columns with a SubClassType of sbclsRegular, if the column is related to a column that is not a key column, the value of this property is equal to the value of the IsPredictable property of the related column. If the parent of the column is a clsColumn object (that is, the column is a child of a nested column) and the IsKey property is True, the value of this property is equal to the value of the IsPredictable property of the parent column. If the parent of the column is a clsMiningModel object and the IsKey property is True, the value of this property is False. If the IsParentKey property of this column is True, this property is False.
Changing the IsPredictable property to True for a column (other than a key column) whose parent is a clsColumn object (that is, the column is a child of a nested column) changes the IsPredictable property of the parent column to True.
For columns with a SubClassType of sbclsNested, changing the IsPredictable property to False changes the IsPredictable property for all child columns whose IsKey, IsParentKey, and IsRelated properties are all False.
Examples
Adding a Column to the Columns Collection
The following example adds a column called Unit to a data mining model's Columns collection Sales. It then enables the column by setting its IsDisabled property to False and makes the column predictable by setting its IsPredictable property to True.
'Make the Unit Sales measure predictable.
Set dsoColumn = dsoDmm.Columns("Unit Sales")
'Enable the column.
dsoColumn.IsDisabled = False
'Make the column predictable.
dsoColumn.IsPredictable = True