Skip to content

view-or-change-algorithm-parameters.md

Latest commit

 

History

History
64 lines (42 loc) · 2.89 KB

view-or-change-algorithm-parameters.md

File metadata and controls

64 lines (42 loc) · 2.89 KB
title View or Change Algorithm Parameters | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
helpviewer_keywords
algorithms [data mining]
mining models [Analysis Services], algorithms
ms.assetid 151b899b-c27a-4a09-bcf5-5c9f0ec24168
author minewiskan
ms.author owend
manager craigg

View or Change Algorithm Parameters

You can change the parameters provided with the algorithms that you use to build data mining models to customize the results of the model.

The algorithm parameters provided in [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] change much more than just properties on the model: they can be used to fundamentally alter the way that data is processed, grouped, and displayed. For example, you can use algorithm parameters to do the following:

  • Change the method of analysis, such as the clustering method.

  • Control feature selection behavior.

  • Specify the size of itemsets or the probability of rules.

  • Control branching and depth of decision trees.

  • Specify a seed value or the size of the internal holdout set used for model creation.

The parameters provided for each algorithm vary greatly; for a list of the parameters that you can set for each algorithm, see the technical reference topics in this section: Data Mining Algorithms (Analysis Services - Data Mining).

Change an algorithm parameter

  1. On the Mining Models tab of Data Mining Designer in [!INCLUDEssBIDevStudioFull], right-click the algorithm type of the mining model for which you want to tune the algorithm, and select Set Algorithm Parameters.

    The Algorithm Parameters dialog box opens.

  2. In the Value column, set a new value for the algorithm that you want to change.

    If you do not enter a value in the Value column, [!INCLUDEssASnoversion] uses the default parameter value. The Range column describes the possible values that you can enter.

  3. Click OK.

    The algorithm parameter is set with the new value. The parameter change will not be reflected in the mining model until you reprocess the model.

View the parameters used in an existing model

  1. In [!INCLUDEssManStudioFull], open a DMX Query window.

  2. Type a query like this one:

    select MINING_PARAMETERS   
from $system.DMSCHEMA_MINING_MODELS  
WHERE MODEL_NAME = '<model name>'

See Also

Mining Model Tasks and How-tos