Dela via


Commands (XMLA)

This reference section contains XML for Analysis (XMLA) elements that can be used within the Command element during an Execute method call.

Element

Description

Alter Element (XMLA)

Contains Analysis Services Scripting Language (ASSL) elements used by the Execute method to alter objects on an instance of Microsoft SQL Server Analysis Services.

Backup Element

Backs up a Microsoft SQL Server Analysis Services database to a backup file.

Batch Element

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

BeginTransaction Element

Begins a transaction on the current session with an Analysis Services instance.

Cancel Element

Cancels a currently running command on an Analysis Services instance.

ClearCache Element

Clears the memory cache for the specified object on an Analysis Services instance.

CommitTransaction Element

Commits a transaction on the current session with an Analysis Services instance.

Create Element

Contains Analysis Services Scripting Language (ASSL) elements used by the Execute method to create objects on an Analysis Services instance.

Delete Element

Deletes an object on an Analysis Services instance.

DesignAggregations Element

Creates aggregations for an aggregation design on an Analysis Services instance.

Drop Element

Deletes attribute members from a dimension.

Insert Element

Inserts attribute members into a dimension.

Lock Element

Locks a specified object on an Analysis Services instance.

MergePartitions Element

Merges the data of one or more source partitions into a target partition, and then deletes the source partitions.

NotifyTableChange Element

Notifies an Analysis Services instance that a change has occurred to tables in a specified data source.

Process Element

Processes objects on an Analysis Services instance.

Restore Element

Restores an Analysis Services database from a backup file.

RollbackTransaction Element

Rolls back a transaction on the current session with an Analysis Services instance.

SetPasswordEncryptionKey Element

Resets or refreshes the encryption key for the SSAS instance.

Statement Element

Ccontains a query or statement to be sent using the Execute method to an instance of Analysis Services.

Subscribe Element

Subscribes to a trace and returns a rowset containing the trace events from an Analysis Services instance.

Synchronize Element

Synchronizes an Analysis Services database with another existing database.

Unlock Element

Unlocks a specified lock on an Analysis Services instance.

Update Element

Updates attribute members in a dimension.

UpdateCells Element

Updates cells in a write-enabled cube.