Using XML for Analysis in Analysis Services (XMLA)
Microsoft SQL Server Analysis Services uses XML for Analysis (XMLA) as its only protocol when communicating with client applications. Because Analysis Services uses XMLA for data definition, data manipulation, and data control support, additional commands are supported by Analysis Services that extend the XML for Analysis 1.1 specification.
In This Section
Topic |
Description |
|---|---|
Describes how to connect to an Analysis Services instance, and how to manage sessions and statefulness in XMLA. |
|
Describes how Analysis Services returns error and warning information for methods and commands in XMLA. |
|
Describes object identifiers and object references, and how to use identifiers and references within XMLA commands. |
|
Details how to use the BeginTransaction, CommitTransaction, and RollbackTransaction commands to explicitly define and manage a transaction on the current XMLA session. |
|
Describes how to use the Cancelcommand to cancel commands, sessions, and connections in XMLA. |
|
Describes how to use the Batch command to run multiple XMLA commands, in serial or in parallel, either within the same transaction or as separate transactions, using a single XMLA Execute method. |
|
Describes how to use the Create, Alter, and Delete commands, along with Analysis Services Scripting Language (ASSL) elements, to define, change, or remove objects from an Analysis Services instance. |
|
Details how to use the Lock and Unlock commands to lock and unlock an Analysis Services database. |
|
Describes how to use the Process command to process an Analysis Services object. |
|
Describes how to use the MergePartitions command to merge partitions on an Analysis Services instance. |
|
Describes how to use the DesignAggregations command, either in iterative or batch mode, to design aggregations for an aggregation design in Analysis Services. |
|
Describes how to use the Backup and Restore commands to back up and restore an Analysis Services database from a backup file. Also describes how to use the Synchronize command to synchronize an Analysis Services database with an existing database on the same instance or on a different instance. |
|
Describes how to use the Insert, Update, and Drop commands to add, change, or delete members from a write-enabled dimension. |
|
Describes how to use the UpdateCells command to change the values of cells in a write-enabled partition. |
|
Details how to use the SetEncryptionKey command to set or reset the instance encryption key for an Analysis Services instance. |
|
Details how to use the ClearCache command to clear the caches of Analysis Services objects. |
|
Describes how to use the Subscribe command to subscribe to and monitor an existing trace on an Analysis Services instance. |
Data Mining with XMLA
XML for Analysis fully supports data mining schema rowsets. These rowsets provide information for querying data mining models using the Discover method. For more information about data mining schema rowsets, see Data Mining Schema Rowsets
For more information about DMX, see Data Mining Extensions (DMX) Reference.