ETL Process for the Report Preparation DTS Task

The Report preparation DTS task is responsible for processing data after it has been imported into the Data Warehouse. The task is composed of four distinct processing phases: processing stored procedures, defining cube partitions, processing OLAP dimensions, and processing physical cube partitions and virtual cubes.

The DTS task can be run in three processing modes: Full, Refresh Data, and Incremental. In all cases, the DTS task performs the following steps:

• Execute each procedure listed in the StoredProcInfo table that has the ProcessingEnabled column set to 1.
• Process each dimension listed in the DimProcInfo table that has the ProcessingEnabled column set to 1.
• Process each partition listed in the CubePartitionInfo for any cube listed in the CubeProcInfo table that has ProcessingEnabled set to 1.

This section contains:

• Processing Stored Procedures
• Defining OLAP Cube Partitions
• Auto-Partitioning
• Changing Existing Partitions
• Partitioning Keys
• Data Warehouse Cube Tables
• Processing OLAP Dimensions
• Processing Physical Cube Partitions
• Restart Logic for the Report Preparation Task
• Tracing the Report Preparation Task

Copyright © 2005 Microsoft Corporation.
All rights reserved.