Analysis Services Processing Task Editor (Analysis Services Page)
Applies To: SQL Server 2016
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:
You cannot perform impact analysis on tabular models.
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.
Some processing options provided, such as process indexes, are not appropriate for tabular models and should not be used.
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.
|Object Name||Lists the specified object names.|
|Type||Lists the types of the specified objects.|
|Process Options||Select a processing option in the list.|
Related Topics: Processing a multidimensional model (Analysis Services)
|Settings||Lists processing settings for the specified objects.|
Add an Analysis Services object to the list.
Select an object, and then click Delete.
Perform impact analysis on the selected object.
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 the processing options and the handling of errors in dimension keys.