Batch Element (XMLA)

Articol
12/09/2022

Performs one or more XML for Analysis (XMLA) commands as a batch operation, either sequentially or in parallel, on an instance of Analysis Services.

Syntax

  
<Command>  
   <Batch Transaction="Boolean" ProcessAffectedObjects="Boolean">  
      <Bindings>...</Bindings>  
      <DataSource>...</DataSource>  
      <DataSourceView>...</DataSourceView>  
      <ErrorConfiguration>...</ErrorConfiguration>  
      <Parallel>...</Parallel>  
      <!-- One or more XMLA commands -->  
   </Batch>  
</Command>

Element characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element relationships

Relationship	Element
Parent elements	Command
Child elements	Bindings, DataSource, DataSourceView, ErrorConfiguration, Parallel One or more of the following XMLA commands: Alter, Backup, BeginTransaction, ClearCache, CommitTransaction, Create, Delete, DesignAggregations, Drop, Insert, Lock, MergePartitions, NotifyTableChange, Process, Restore, RollbackTransaction, SetPasswordEncryptionKey, Statement, Subscribe, Synchronize, Unlock, Update, UpdateCells

Attributes

Attribute	Description
ProcessAffectedObjects	(Optional Boolean attribute) Indicates whether all objects that require reprocessing will be processed. If set to true, the Analysis Services instance processes any objects that require reprocessing as a result of processing an object included in the Batch command. If set to false, the Analysis Services instance processes only those objects included in the Batch command.
Transaction	(Optional Boolean attribute) Indicates whether the command included in the Batch command are treated as a single transaction or individual transactions. If set to true, all of the commands included in the Batch command are considered a single transaction. If any command fails, the commands executed prior to the failed command are rolled back, and the Batch command stops without executing subsequent commands. If set to false, the Batch command attempts to execute every command, and commits the results of each command that completes successfully.

Attribute

Description

ProcessAffectedObjects

(Optional Boolean attribute) Indicates whether all objects that require reprocessing will be processed.

If set to true, the Analysis Services instance processes any objects that require reprocessing as a result of processing an object included in the Batch command.

If set to false, the Analysis Services instance processes only those objects included in the Batch command.

Transaction

(Optional Boolean attribute) Indicates whether the command included in the Batch command are treated as a single transaction or individual transactions.

If set to true, all of the commands included in the Batch command are considered a single transaction. If any command fails, the commands executed prior to the failed command are rolled back, and the Batch command stops without executing subsequent commands.

If set to false, the Batch command attempts to execute every command, and commits the results of each command that completes successfully.

Remarks

Warning

Command/Execute/Statement is currently not supported in a Batch operation.

Partajați prin