Step 2: Automate the Predictor Model Rebuild Process

Use the Predictor DTS task to automate the model rebuilds on a regular, recurring basis.

Ee798249.note(en-US,CS.20).gif Note

Build one analysis model at a time. If you schedule two or more models to be built simultaneously, the DTS task will fail. To schedule building multiple models, you must schedule them to run one after another.

To automate the rebuilding of Prediction models

Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
Right-click Data Transformation Services, and then click New Package.

Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.
On the Task menu, click Model Builder (Commerce Server).

In the Model Builder Properties dialog box, do the following:

Use this	To do this
Description	Type a description for this task. The maximum number of characters for the description is 255 characters.
Source type	Select either Site or Data Warehouse from the drop-down list.
Site name	Select the site name from the drop-down list. If you selected Site as the source type, you must select the site for which you want to rebuild an analysis model.
Data Warehouse name	Select the name of the Data Warehouse from the drop-down list. If you selected Data Warehouse as the source type, you must select the Data Warehouse associated with the sites for which you want to rebuild an analysis model.
Model to rebuild	Select an analysis model from the drop-down list.

In the Archive properties section, do the following:

Use this	To do this
Archive current model	Select this check box to archive the analysis model.
Archived model name suffix	Select either Date of rebuild or Version number from the drop-down list.
Archived model name	Type a model name if you want to use anything other than the default name provided.

In the Retry properties section, do the following:

Use this	To do this
Number of retry attempts	Type the number of times (between 0 and 255) you want the Data Warehouse to retry if encountered with erroneous data. The default number of retries is 10.
Time between attempts (seconds)	Type the amount of time in seconds (between 1 and 3600) you want the Data Warehouse to wait before it attempts to retry. The default timeout interval is 30 seconds.

Click OK.
On the Package menu, click Execute.

The Executing Package dialog box appears, showing the progress of you're the model build process. When the model build process is complete, the Package Execution Results dialog box informs you it completed successfully.
Click OK, and then click Done.

The specified analysis model will be rebuilt on a scheduled basis with current data from the Data Warehouse.

Additional resources