This documentation is archived and is not being maintained.

CommitTransaction Element (XMLA)

Commits a transaction on the current session with a Microsoft SQL Server 2005 Analysis Services (SSAS) instance.

   <CommitTransaction />

Characteristic Description

Data type and length


Default value



0-n: Optional element that can occur more than once.

Relationship Element

Parent elements


Child elements


The CommitTransaction command commits an active transaction, explicitly defined using the BeginTransaction element, on the current session. If an active transaction does not already exist, an error occurs. If an active transaction already exists, the Analysis Services instance decrements the reference count of transactions for the current session. If the reference count of explicitly defined active transactions reaches zero, the Analysis Services instance commits the transaction.