Prepare Reports Properties Dialog Box
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:
|
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. |