ScalarMiningStructureColumn.DiscretizationBucketCount Property

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
Dim instance As ScalarMiningStructureColumn
Dim value As Integer

value = instance.DiscretizationBucketCount

instance.DiscretizationBucketCount = value
[TypeConverterAttribute("Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")]
public int DiscretizationBucketCount { get; set; }
[TypeConverterAttribute(L"Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")]
property int DiscretizationBucketCount {
    int get ();
    void set (int value);
[<TypeConverterAttribute("Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")>]
member DiscretizationBucketCount : int with get, set
function get DiscretizationBucketCount () : int
function set DiscretizationBucketCount (value : int)

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 P:Microsoft.AnalysisServices.ScalarMiningStructureColumn.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).