Page 178 - DCAP606_BUSINESS_INTELLIGENCE
P. 178
Unit 12: Understanding Data Mining Tools
Identify the dimensions of datasets or the probability of rules. Notes
Control branching and deepness of decision trees.
12.3.1 Change an Algorithm Parameter
1. On the Mining Models tab of Data Mining Designer in SQL Server Data Tools (SSDT),
right-click the algorithm type and select Set Algorithm Parameters. The Algorithm
Parameters dialog box will open.
Figure 12.2: An algorithm Parameters dialog box
Source: http://media.techtarget.com/digitalguide/images/Misc/dm_6.gif
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, Analysis Services 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.
12.3.2 View the Parameters
To view the parameters used in an existing model:
In SQL Server Management Studio, open a DMX Query window.
Type a query like this one:
select MINING_PARAMETERS
from $system.DMSCHEMA_MINING_MODELS
WHERE MODEL_NAME = ‘<model name>’
LOVELY PROFESSIONAL UNIVERSITY 173
