Automatically Rebuilding Analysis Models

  • Article

You use the Model Builder DTS task to automatically rebuild analysis models. You use the Predictor resource to build analysis models manually before you use the Model Builder task to rebuild models. After you build a model manually using the Predictor resource, you can use the Model Builder task to schedule automatic rebuilding of the analysis model.

Each time an analysis model is built, it is based on the data currently in the Data Warehouse. It is important to rebuild analysis models when you think your Web site or user behavior has changed or when a long period of time has passed without rebuilding an analysis model.

You can use the Model Builder DTS task to rebuild analysis models for a specified site or for all sites associated with a specified Data Warehouse.

Ee797049.note(en-US,CS.20).gifNote

  • After you build a model, you can set the Predictor Refresh interval property, which specifies how often the PredictorClient object should check to determine if a model reload is necessary.

    The PredictorClient object uses the Refresh interval property it got when initialized to determine when next to check the Administration database. If the Refresh interval property is set to 2 days, then the PredictorClient object will check the Administration database in two days.

    For instructions, see Deploying Predictor.

To rebuild analysis models

  1. Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  2. 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.

  3. On the Task menu, click Model Builder (Commerce Server).

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

    Use this To do this
    Description Type a description for this task.
    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.

    Ee797049.note(en-US,CS.20).gifNote

    • If no site was selected when an analysis model was build from an analysis configuration model, select unknown for the Site name.
    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. This option will also rebuild all the models on all the Web sites at the same time.
    Model to rebuild Select an analysis model from the drop-down list.

  5. 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. Using this option you can review your old model and trace changes in the new 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.

  6. 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 DTS task to retry if encountered with erroneous data or fail-over. 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 DTS task to wait before it attempts to retry. The default timeout interval is 30 seconds.

  7. Click OK.

  8. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.

  9. Click OK, and then click Done.

The specified analysis model is rebuilt with current data from the Data Warehouse.

See Also

Deploying Predictor

Securing a Predictor Deployment

Copyright © 2005 Microsoft Corporation.
All rights reserved.