TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Incremental Update Dialog Box (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

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.

TermDefinition
Measure GroupSelect 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.
PartitionSelect 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.
TableClick to update the object from a table.
Data source or viewSelect 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 nameSelect 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.
QueryClick to update the object from a query.
Data SourceSelect 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 queryType 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.

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Process Dialog Box (Analysis Services - Multidimensional Data)

Community Additions

ADD
Show:
© 2016 Microsoft