XML for Analysis Compliance (XMLA)

 

Applies To: SQL Server 2016 Preview

The XML for Analysis 1.1 specification describes an open standard that supports data access to data sources that reside on the World Wide Web. This topic details the level of compliance with the XML for Analysis 1.1 specification that is supported by Microsoft SQL Server Analysis Services.

Analysis Services complies with all mandatory items listed in the XML for Analysis 1.1 specification. In addition, Analysis Services implements the following optional item described in the XML for Analysis 1.1 specification.

ItemSpecificationImplementation
Session supportThe SOAP header elements listed in "Support for Statefulness in XML for Analysis" section of the XML for Analysis 1.1 specification.All listed SOAP header elements are supported by Analysis Services, as described within the specification.

Analysis Services also extends the XML for Analysis 1.1 specification to support the following additional features and capabilities.

ItemSpecificationImplementation
Protocol negotiationNo information contained in the XML for Analysis 1.1 specificationProtocolCapabilities header element added by Analysis Services to support negotiation of protocol capabilities.
XML for Analysis (XMLA) commands supported by the Discover methodThe following commands are supported by the XML for Analysis 1.1 specification:

 Statement Element (XMLA)
The following commands are supported by Analysis Services:

 Alter Element (XMLA)

 Backup Element (XMLA)

 Batch Element (XMLA)

 BeginTransaction Element (XMLA)

 Cancel Element (XMLA)

 ClearCache Element (XMLA)

 CommitTransaction Element (XMLA)

 Create Element (XMLA)

 Delete Element (XMLA)

 DesignAggregations Element (XMLA)

 Drop Element (XMLA)

 Insert Element (XMLA)

 Lock Element (XMLA)

 MergePartitions Element (XMLA)

 NotifyTableChange Element (XMLA)

 Process Element (XMLA)

 Restore Element (XMLA)

 RollbackTransaction Element (XMLA)

 Statement Element (XMLA)

 Subscribe Element (XMLA)

 Synchronize Element (XMLA)

 Unlock Element (XMLA)

 Update Element (XMLA)

 UpdateCells Element (XMLA)
Column errors in tabular rowsetsNot listed in XML for Analysis 1.1 specification.The Error element is used by Analysis Services to report errors for column elements contained in a row element.

XML for Analysis (XMLA) Reference

Community Additions

ADD
Show: