Committing a Transaction
Use the Microsoft® ActiveX® Data Objects (ADO) Commit transaction method to commit updates to the writeback table of a write-enabled cube. An error results if the transaction attempts to commit updates to a table other than the writeback table or if the cube is not write-enabled.
If a transaction includes updates for multiple cubes, the updates may be successful for some cubes and unsuccessful for others. Therefore, a transaction should only include updates for a single cube. For more information, see Transaction Scope.
Some possible causes of commit failure are commit time-out during a writeback attempt, attempting to commit to a cube that is not write-enabled, or network errors. For more information about errors in transaction processing, see the ADO documentation.