XML for Analysis: Difference between revisions

Revision as of 16:50, 17 January 2018

Latest revision as of 18:10, 8 March 2025

(7 intermediate revisions by 7 users not shown)

Line 1:

'''XML for Analysis''' (abbreviated as '''XMLA''') is an industry standard for data access in analytical systems, such as [[Onlineonline analytical processing|OLAP]] (OLAP) and [[data mining]]. XMLA is based on other industry standards such as [[XML]], [[SOAP]] and [[HTTP]]. XMLA is maintained by '''XMLA Council''' with [[Microsoft]], [[Oracle Hyperion Solutions Corporation|Hyperion]] (acquired by Oracle Corporation) and [[SAS Institute|SAS]] being the official XMLA Council founder members.

==History==

The XMLA specification was first proposed by [[Microsoft]] as a successor for [[OLE DB for OLAP]] in April 2000. By January 2001 it was joined by [[Hyperion Solutions Corporation|Hyperion]] endorsing XMLA. The 1.0 version of the standard was released in April 2001, and in September 2001 the XMLA Council was formed. In April 2002 [[SAS Institute|SAS]] joined Microsoft and Hyperion as founding member of XMLA Council.<ref>{{cite web|title=XML for Analysis gathers steam |url=http://www.olapreport.com/Comment_APIs.htm |deadurlurl-status=yesusurped |archiveurl=https://web.archive.org/web/20080528220113/http://www.olapreport.com/Comment_APIs.htm |archivedate=May 28, 2008 }}</ref> With time, more than 25 companies joined with their support for the standard.

==API==

XMLA consists of only two [[SOAP]] methods: execute and discover.<ref>{{cite web|title=XML for Analysis Specification|date=30 June 2006 |url=http://msdn.microsoft.com/en-us/library/ms977626.aspx}}</ref> It was designed in such a way to preserve simplicity.

* Execute

* Discover

===Execute===

Line 23 ⟶ 20:

==Query language==

XMLA specifies '''MDXML''' as the query language. In the XMLA 1.1 version, the only construct in MDXML is an [[Multidimensional Expressions|MDX]] statement enclosed in the <Statement> tag.<ref>{{cite web|title=MDX / mdXML |url=http://www.xmlforanalysis.com/mdx.htm |deadurlurl-status=yesusurped |archiveurl=https://web.archive.org/web/20080907093211/http://www.xmlforanalysis.com/mdx.htm |archivedate=September 7, 2008 }}</ref>

==Example==

Below is an example of XMLA Execute request with MDX query in command.

<sourcesyntaxhighlight lang="xml">

<soap:Envelope>

<soap:Body>

Line 46 ⟶ 43:

</soap:Body>

</soap:Envelope>

</syntaxhighlight>

</source>

==Session management==