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

Impact Analysis Dialog Box (Analysis Services - Multidimensional Data)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Use the Impact Analysis dialog box in SQL Server Data Tools (SSDT) and SQL Server Management Studio to identify and optionally process dependent objects that are affected if the objects listed in the Process dialog box are processed. You can display the Impact Analysis dialog box by clicking Impact Analysis from the Process dialog box.

Note Note

An object appears more than once if it is affected in more than one way.

Object list

Displays a list of dependent objects in a grid. The grid contains the following columns:

Object Name

Displays the name of the dependent object that may need to be processed. The icon to the left of the name indicates the object type.


Displays the type of dependent object that may need to be processed.

Impact Type

Displays the effect that processing the objects in the Process dialog box has on the dependent object. The following table lists the possible effects of processing and notes whether each one results in a warning or an error.



Object will be cleared (unprocessed)


Object would be invalid


Aggregation would be dropped


Flexible aggregation would be dropped


Indexes will be dropped


Non-child object will be processed


Process Object

Select the dependent objects that you want to process with the processing operation. Dependent objects that are not selected must be processed after the processing operation is finished. Otherwise, they cannot be used.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft