Running the Report Caching DTS Task

Note

• You must install Microsoft Office XP Web Components on the computer that is going to run the Report caching DTS task. Office XP Web Components are installed with Office XP. You can also install Office XP Web Components by running OWC10.exe, which is located in the following directory on the Commerce Server 2002 CD: \Program Files\Microsoft Commerce Server 2002\Widgets\OWC10.

You use the Report caching DTS task to increase the processing speed of the dynamic OLAP reports run from the Business Desk.

The Report caching task pre-executes dynamic OLAP reports stored in the SQL Data Warehouse to get the query results cached on the Analysis server. When this is done, subsequent execution of the reports can be two orders of magnitude faster than the original report execution.

The task queries the ReportPreExec table in the SQL Data Warehouse for a list of reports that are to be pre-executed. It executes only those reports that are of type dynamic OLAP and have ReportIds listed in the table.

You can configure the Report caching task to run in either site mode or Data Warehouse mode.

• Site mode. The task runs each dynamic OLAP report in the ReportPreExec table, applying the site filter where appropriate for the specified site.
• Data Warehouse mode. The task runs each report once for each site sharing the Data Warehouse, again applying the site filter where appropriate for each individual site.

The task does not detect if a report execution fails. It ignores the error and proceeds to the next report.

See Also

Troubleshooting the Data Warehouse Import Process

Copyright © 2005 Microsoft Corporation.
All rights reserved.