Commands (XMLA)

 

Applies To: SQL Server 2016 Preview

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

ElementDescription
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 ElementBacks up a Microsoft SQL Server Analysis Services database to a backup file.
Batch ElementPerforms 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 ElementBegins a transaction on the current session with an Analysis Services instance.
Cancel ElementCancels a currently running command on an Analysis Services instance.
ClearCache ElementClears the memory cache for the specified object on an Analysis Services instance.
CommitTransaction ElementCommits a transaction on the current session with an Analysis Services instance.
Create ElementContains Analysis Services Scripting Language (ASSL) elements used by the Execute method to create objects on an Analysis Services instance.
Delete ElementDeletes an object on an Analysis Services instance.
DesignAggregations ElementCreates aggregations for an aggregation design on an Analysis Services instance.
Drop ElementDeletes attribute members from a dimension.
Insert ElementInserts attribute members into a dimension.
Lock ElementLocks a specified object on an Analysis Services instance.
MergePartitions ElementMerges the data of one or more source partitions into a target partition, and then deletes the source partitions.
NotifyTableChange ElementNotifies an Analysis Services instance that a change has occurred to tables in a specified data source.
Process ElementProcesses objects on an Analysis Services instance.
Restore ElementRestores an Analysis Services database from a backup file.
RollbackTransaction ElementRolls back a transaction on the current session with an Analysis Services instance.
Statement ElementCcontains a query or statement to be sent using the Execute method to an instance of Analysis Services.
Subscribe ElementSubscribes to a trace and returns a rowset containing the trace events from an Analysis Services instance.
Synchronize ElementSynchronizes an Analysis Services database with another existing database.
Unlock ElementUnlocks a specified lock on an Analysis Services instance.
Update ElementUpdates attribute members in a dimension.
UpdateCells ElementUpdates cells in a write-enabled cube.

Community Additions

ADD
Show: