SpecialFlag (clsColumn)

Analysis Services Programming

Analysis Services Programming

SpecialFlag (clsColumn)

The SpecialFlag property assists the Distribution property in identifying the statistical nature of the column's data values for model optimization purposes.

Data Type

String

Access

Read/write for columns with a SubClassType of sbclsRegular whose IsKey and IsParentKey properties are False, read-only for all others.

Remarks

For columns whose IsKey or IsParentKey properties are set to True and columns with a SubClassType of sbclsNested, this property returns an empty string.

This property suggests the column contents to the mining model. This suggestion is used to optimize the mining model's MiningAlgorithm and can be left unspecified.

Supported values for this property are listed in the MINING_SERVICES schema rowset in the SUPPORTED_SPECIAL_FLAGS column.

Examples
Building a New Column

The following example builds a new column and sets its SpecialFlag property to PROBABILITY:

Set dsoColumn = dsoNestedCol.Columns.AddNew("pOn Sale")
dsoColumn.SourceColumn = "Sales.pOnSale"
dsoColumn.DataType = adDouble
dsoColumn.RelatedColumn = "On Sale"
dsoColumn.SpecialFlag = "PROBABILITY"

See Also

clsColumn

Data Mining Schema Rowsets

MiningAlgorithm