Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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(L"Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")]
public:
property int DiscretizationBucketCount {
	int get ();
	void set (int value);
}

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.