Skip to content

batch-element-xmla.md

Latest commit

 

History

History
83 lines (68 loc) · 6.28 KB

batch-element-xmla.md

File metadata and controls

83 lines (68 loc) · 6.28 KB
title Batch Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Batch Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
urn:schemas-microsoft-com:xml-analysis#Batch
microsoft.xml.analysis.batch
helpviewer_keywords
Batch command
ms.assetid 818f3212-9605-4e34-8623-1154d9fae1f0
caps.latest.revision 14
author jeannt
ms.author jeannt
manager erikre

Batch Element (XMLA)

Performs one or more XML for Analysis (XMLA) commands as a batch operation, either sequentially or in parallel, on an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion].

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 [!INCLUDEssASnoversion] instance processes any objects that require reprocessing as a result of processing an object included in the Batch command.

If set to false, the [!INCLUDEssASnoversion] 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.

For more information about performing batch operations in XMLA, see Performing Batch Operations (XMLA).

See Also

Commands (XMLA)