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.
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.
Describes how to use the Cancelcommand to cancel commands, sessions, and connections in XMLA.
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.
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 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.
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.