Muokkaa

Jaa


XML for Analysis (XMLA) Compliance

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

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 article details the level of compliance with the XML for Analysis 1.1 specification supported by all Analysis Services platforms: Azure Analysis Services, SQL Server Analysis Services, and Power BI Premium.

Compliant items

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.

Item Specification Implementation
Session support The 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.

Extensions

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

Item Specification Implementation
Protocol negotiation No information contained in the XML for Analysis 1.1 specification ProtocolCapabilities header element added by Analysis Services to support negotiation of protocol capabilities.
XML for Analysis (XMLA) commands supported by the Discover method The 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 rowsets Not 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.