ETL Process for the Report Caching DTS Task

Article
11/12/2009

The Report Caching DTS task runs OLAP report definitions stored in the Data Warehouse before they are built by using the Analysis category of Business Desk. The results are then cached on the OLAP server for more expedient retrieval when the report is run from Business Desk. Reports previously cached by the Report Caching DTS task can run two orders of magnitude faster than non-cached reports.

This task can be run on a Data Warehouse that contains one or more sites, and can be run per site or per Data Warehouse. If the task is run on all sites in a Data Warehouse, it will run each report one time per site.

The Report Caching DTS task uses the ReportPreExec table to determine which reports to run and in what order to run them. For more information about the ReportPreExec table, see ReportPreExec Table.

The Report Caching DTS task uses the OutputDebugString function to report trace messages. Use a tool capable of intercepting debugging output to intercept and display debug strings, and examine the systematic operations being carried out by the Report preparation task. This differs from the other DTS tasks that use the CSDWDbgSrv.EXE utility to display trace messages.

The Report Caching DTS task ignores errors that occur while running reports. If an error that is not related to running reports is encountered during task execution, the Report Caching task checks for the retry status of the error. If the error is listed as the REG_MULTI_SZ value "Retryable Errors" under the registry key HKLM\SOFTWARE\MICROSOFT\Commerce Server\OLAPCacheWarmer, the Report Caching task waits for the configured retry interval and reattempts the processing operation until the configured number of retries is exhausted.

You can add entries to or remove entries from the list to modify the retry behavior of the Report Caching task.

ETL Process for the Report Caching DTS Task

See Also

Additional resources