ScalarMiningStructureColumn.DiscretizationBucketCount Property


Updated: May 24, 2016

Gets or sets the number of buckets into which to discretize the column values.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

<TypeConverterAttribute("Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")>
Public Property DiscretizationBucketCount As Integer

Property Value

Type: System.Int32

An Integer that contains the number of buckets into which to discretize the column values.

The value of the DiscretizationBucketCount determines how many groups are created when values for the ScalarMiningStructureColumn are discretized. Discretization refers to the process of organizing values into a number of groups. If a value is not specified for the number of groups, or if zero is specified for the value of the property, then Microsoft SQL Server Analysis Services creates an appropriate number of groups depending on the discretization method.

Note that the method for discretization is different depending on whether your data is relational or is part of an OLAP cube.

For relational data mining, you can specify the number of buckets by setting the value of the DiscretizationBucketCount property. This property defaults to 5.

Note: For OLAP data mining, the algorithm automatically computes the number of buckets to generate, by using the following equation, where n is the number of distinct values of data in the column:

Number of Buckets = sqrt(n)

If you do not want Analysis Services to calculate the number of buckets, you can use the DiscretizationBucketCount property to manually specify the number of buckets.

For more information about discretization methods in data mining solutions, see Discretization Methods (Data Mining).

Return to top