Incremental Update Dialog Box (SSAS)

Use the Incremental Update dialog box in Business Intelligence Development Studio and SQL Server Management Studio to define the settings that are used when measure groups and partitions are incrementally updated. You can display the Incremental Update dialog box by clicking Configure in the Settings column of the Object list grid in the Process dialog box.

Options

Term

Definition

Measure Group

Select the measure group to incrementally update.

Note:

This option is enabled only if you are incrementally updating a cube. If you are incrementally updating a measure group or partition, this option is disabled.

Partition

Select the partition to update.

Note:

This option is enabled only if you are incrementally updating a cube. If you are incrementally updating a measure group or partition, this option is disabled.

Table

Click to update the object from a table.

Data source or view

Select the data source or data source view in which the source table is located.

Note:

This option is enabled only if Table is selected.

Table schema and name

Select the source table used to retrieve data for incrementally updating the cube, measure group, or partition.

Note:

This option is enabled only if Table is selected.

Query

Click to update the object from a query.

Data Source

Select the data source in which the tables to be queried are located.

Note:

This option is enabled only if Query is selected.

Text of the query

Type the text of the query used to retrieve data for incrementally updating the cube, measure group, or partition.

Note:

This option is enabled only if Query is selected.

See Also

Reference

Analysis Services Designers and Dialog Boxes (SSAS)
Process Dialog Box (SSAS)

Help and Information

Getting SQL Server 2005 Assistance