Export (0) Print
Expand All
1 out of 5 rated this helpful - Rate this topic

XML for Analysis Overview (XMLA)

Updated: 17 July 2006

The XML for Analysis (XMLA) open standard supports data access to data sources that reside on the World Wide Web. Microsoft SQL Server 2005 Analysis Services (SSAS) implements XMLA per the XMLA 1.1 specification.

The XMLA open standard describes two generally accessible methods: Discover and Execute. These methods use the loosely-coupled client and server architecture supported by XML to handle incoming and outgoing information on an instance of Analysis Services.

The Discover method obtains information and metadata from a Web service. This information can include a list of available data sources, as well as information about any of the data source providers. Properties define and shape the data that is obtained from a data source. The Discover method is a common method for defining the many types of information a client application may require from data sources on Analysis Services instances. The properties and the generic interface provide extensibility without requiring you to rewrite existing functions in a client application.

The Execute method allows applications to run provider-specific commands against XMLA data sources.

Although the XMLA protocol is optimized for Web applications, it can also be leveraged for LAN-oriented applications. The following applications can benefit from this XML-based API:

  • Client/server applications that require flexible technology between clients and the server
  • Client/server applications that target multiple operating systems
  • Clients that do not require significant state in order to increase server capacity

XMLA is the protocol used by business intelligence applications that employ the Unified Dimensional Model (UDM) methodology. For more information about the Unified Dimensional Model methodology, see Unified Dimensional Model.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.