Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Analysis Services Processing Task Editor (Analysis Services Page)


Use the Analysis Services page of the Analysis Services Processing Task Editor dialog box to specify an Analysis Services connection manager, select the analytic objects to process, and set processing and error handling options.

When processing tabular models, keep the following in mind:

  1. You cannot perform impact analysis on tabular models.

  2. Some processing options for tabular mode are not exposed, such as Process Defrag and Process Recalc. You can perform these functions by using the Execute DDL task.

  3. Some processing options provided, such as process indexes, are not appropriate for tabular models and should not be used.

  4. Batch settings are ignored for tabular models.

To learn about this task, see Analysis Services Processing Task.

Analysis Services connection manager

Select an existing Analysis Services connection manager in the list or click New to create a new connection manager.


Create a new Analysis Services connection manager.

Related Topics: Analysis Services Connection Manager, Add Analysis Services Connection Manager Dialog Box UI Reference

Object list



Object Name

Lists the specified object names.


Lists the types of the specified objects.

Process Options

Select a processing option in the list.

Related Topics: Processing a multidimensional model (Analysis Services)


Lists processing settings for the specified objects.


Add an Analysis Services object to the list.


Select an object, and then click Delete.

Impact Analysis

Perform impact analysis on the selected object.

Related Topics: Impact Analysis Dialog Box (Analysis Services - Multidimensional Data)

Batch Settings Summary



Processing order

Specifies whether objects are processed sequentially or in a batch; if parallel processing is used, specifies the number of objects to process concurrently.

Transaction mode

Specifies the transaction mode for sequential processing.

Dimension errors

Specifies the task behavior when errors occur.

Dimension key error log path

Specifies the path of the file to which errors are logged.

Process affected objects

Indicates whether dependent or affected objects are also processed.

Change Settings

Change the processing options and the handling of errors in dimension keys.

Related Topics: Change Settings Dialog Box (Analysis Services - Multidimensional Data)

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

Community Additions

© 2015 Microsoft