XML for Analysis (XMLA) Reference

APPLIES TO:yesSQL Server Analysis ServicesyesAzure Analysis Services

Microsoft SQL Server Analysis Services uses the XML for Analysis (XMLA) protocol to handle all communication between client applications and an Analysis Services instance. At their most basic level, other client libraries such as ADOMD.NET and AMO construct requests and decode responses in XMLA, serving as an intermediary to an Analysis Services instance, which uses XMLA exclusively.

To support the discovery and manipulation of data in both multidimensional and tabular formats, the XMLA specification defines two generally accessible methods, Discover and Execute, and a collection of XML elements and data types. Because XML allows for a loosely coupled client and server architecture, both methods handle incoming and outgoing information in XML format. Analysis Services is compliant with the XMLA 1.1. specification, but also extends it to include data definition and manipulation capability, implemented as annotations on the Discover and Execute methods. The extended XML syntax is referred to as Analysis Services Scripting Language (ASSL). ASSL builds on the XMLA specification without breaking it. Interoperability based on XMLA is ensured whether you use just XMLA, or XMLA and ASSL together.

As a programmer, you can use XMLA as a programmatic interface if solution requirements specify standard protocols, such as XML, SOAP, and HTTP. Programmers and administrators can also use XMLA on an ad hoc basis to retrieve information from the server or run commands.

In This Section

Topic Description
XML Elements (XMLA) Describes elements in the XMLA specification.
XML Data Types (XMLA) Describes data types in the XMLA specification.
XML for Analysis Compliance (XMLA) Describes the level of compliance with the XMLA 1.1 specification.

Developing with Analysis Services Scripting Language (ASSL)

XML for Analysis Schema Rowsets

Developing with ADOMD.NET

Developing with Analysis Management Objects (AMO)

See Also

Understanding Microsoft OLAP Architecture