Incremental Update Dialog Box (Analysis Services - Multidimensional Data)
Use the Incremental Update dialog box in SQL Server Data Tools (SSDT) 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.
Select the measure group to incrementally update.
Select the partition to update.
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.
Table schema and name
Select the source table used to retrieve data for incrementally updating the cube, measure group, or partition.
Click to update the object from a query.
Select the data source in which the tables to be queried are located.
Text of the query
Type the text of the query used to retrieve data for incrementally updating the cube, measure group, or partition.