XML for Analysis: Difference between revisions

Revision as of 13:46, 21 August 2024

Latest revision as of 18:10, 8 March 2025

(One intermediate revision by the same user not shown)

Line 2:

==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 |url-status=deadusurped |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==

Line 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 |url-status=deadusurped |archiveurl=https://web.archive.org/web/20080907093211/http://www.xmlforanalysis.com/mdx.htm |archivedate=September 7, 2008 }}</ref>

==Example==