Export (0) Print
Expand All

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")]
[DefaultValueAttribute()]
public int DiscretizationBucketCount { get; set; }

Property Value

Type: 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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft