DimensionAttribute.DiscretizationMethod Property

 

Applies To: SQL Server 2016 Preview

Gets or sets the method to be used for discretization.

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

Syntax

[DefaultValueAttribute(DiscretizationMethod.None)]
public DiscretizationMethod DiscretizationMethod { get; set; }
public:
[DefaultValueAttribute(DiscretizationMethod::None)]
property DiscretizationMethod DiscretizationMethod {
    DiscretizationMethod get();
    void set(DiscretizationMethod value);
}
[<DefaultValueAttribute(DiscretizationMethod.None)>]
member DiscretizationMethod : DiscretizationMethod with get, set
<DefaultValueAttribute(DiscretizationMethod.None)>
Public Property DiscretizationMethod As DiscretizationMethod

Property Value

Type: Microsoft.AnalysisServices.DiscretizationMethod

A DiscretizationMethod object containing the method to be used for discretization.

Remarks

The value of DiscretizationMethod determines how values for the DimensionAttribute are discretized, or organized into a specific set of groups.

This property can be set to the following values:

Value

Description

Automatic

Equivalent to the AUTOMATIC discretization method for mining structure columns.

EqualAreas

Equivalent to the EQUAL_AREAS discretization method for mining structure columns.

Clusters

Equivalent to the CLUSTERS discretization method for mining structure columns.

Thresholds

Equivalent to the THRESHOLDS discretization method for mining structure columns.

EqualRanges

Equivalent to the EQUAL_RANGES discretization method for mining structure columns.

For data mining, the method that is used to discretize data can be different depending on whether your data is relational or stored in an OLAP dimension.

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.

Note

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

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

See Also

DimensionAttribute Class
Microsoft.AnalysisServices Namespace

Return to top