Prepare Reports Properties Dialog Box

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

Use the Prepare Reports Properties dialog box to specify how the Report Preparation DTS task populates the online analytical processing (OLAP) cubes with the data in the Data Warehouse. Commerce Server uses OLAP cubes to organize the summarized data in the Data Warehouse so that report generation is completed faster. You must run the Report Preparation DTS task every time that you import or delete data from the Data Warehouse. For information about OLAP cubes, see SQL Server Books Online.

Use this

To do this

Description

Type a description for the DTS task. The maximum number of characters for the description is 255 characters.

Data warehouse

Select from the drop-down list the Data Warehouse on which to run the Report Preparation DTS task.

Sites

Select from the list the site that contains the data that you want to use in analysis reports.

Processing Mode

Select one of the following options:

  • Full. Select to perform full cube processing.

  • Refresh Data. Select to update all data in the cubes.

  • Incremental. Select to perform incremental cube processing.

Number of retries

Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10 times.

Seconds between retries

Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

See Also

Other Resources

How to Run the Report Preparation DTS Task

Importing Data into the Data Warehouse