Incremental Updates and Partitions

Analysis Services

Analysis Services

Incremental Updates and Partitions

When you create and manage partitions in multiple-partition cubes, you must take special precautions to ensure accurate cube data. Although these precautions do not usually apply to single-partition cubes, they do apply when you incrementally update them.

When you incrementally update any cube, a temporary partition is created and merged with an existing partition. When you run the Incremental Update Wizard, you specify the data source and fact table of the temporary partition. You can also specify a filter to limit the contents of the temporary partition. If the cube contains multiple partitions, you must specify the partition into which the temporary partition is merged. If the cube contains only one partition, the temporary partition is merged into that partition.

To ensure accurate cube data, before you perform an incremental update on any cube, be sure you understand the special precautions related to data integrity that apply to multiple-partition cubes. For more information, see Managing Partitions.

See Also

Processing Cubes