Share via


Classified Columns

You can define a classified column in a mining model in Microsoft SQL Server 2005 Analysis Services (SSAS), to include information in that column that describes another column in the model. For example, you could define a classified column that contains standard deviations for another column in the model, such as for a column that describes a customer's total purchases for a calendar year.

The data type of a classified column must be either Long or Double.

The following list describes the content types that Analysis Services supports for classified columns.

  • PROBABILITY
    The value in the column is the probability of the associated value, and is a number between 0 and 1.
  • VARIANCE
    The value in the column is the variance of the associated value.
  • STDEV
    The value in the column is the standard deviation of the associated value.
  • PROBABILITY_VARIANCE
    The value in the column is the variance of the probability for the associated value.
  • PROBABILITY_STDEV
    The value in the column is the standard deviation of the probability for the associated value.
  • SUPPORT
    The value in the column is the weight, or case replication factor, of the associated value.

Note

The algorithms that Analysis Services provides do not support using classified columns.

See Also

Tasks

How to: Change the Properties of a Mining Structure

Concepts

Content Types (Data Mining)
Data Mining Concepts
Mining Structures (Analysis Services)
Data Types (Data Mining)

Other Resources

Mining Structure Columns

Help and Information

Getting SQL Server 2005 Assistance