Gets or sets the number of buckets into which to discretize the column values.
Assembly: Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)
'Declaration <TypeConverterAttribute("Microsoft.AnalysisServices.Design.MiningModelColumnDiscretizationBucketsTypeConverter, Microsoft.AnalysisServices.Design")> _ Public Property DiscretizationBucketCount As Integer Get Set 'Usage Dim instance As ScalarMiningStructureColumn Dim value As Integer value = instance.DiscretizationBucketCount instance.DiscretizationBucketCount = value
Property ValueType: System.Int32
An Integer that contains the number of buckets into which to discretize the column values.
The value of the 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 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).