XML for Analysis: Difference between revisions

Revision as of 17:54, 20 July 2016

Revision as of 12:49, 7 September 2016

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 |deadurl=yes |archiveurl=httphttps://web.archive.org/web/20080528220113/http://www.olapreport.com:80/Comment_APIs.htm |archivedate=May 28, 2008 }}</ref> With time, more than 25 companies joined with their support for the standard.

==API==

Line 23:

==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 |deadurl=yes |archiveurl=httphttps://web.archive.org/web/20080907093211/http://www.xmlforanalysis.com/mdx.htm |archivedate=September 7, 2008 }}</ref>

==Example==

Line 73:

* [[Mondrian OLAP server]]

* [[Simba Technologies]] [http://www.simba.com/olap-sdk.htm SimbaProvider XMLA SDK]

* [[SAP NetWeaver Business Intelligence]] [httphttps://web.archive.org/web/20120308041620/http://help.sap.com/saphelp_nw04/helpdata/en/a7/18533d6dd60610e10000000a114084/content.htm SAP BW MDX Syntax]

* [https://github.com/Wondersoft/olaper Olaper: XML/A server for SQL databases]

===Libraries ===

* [http://msdn.microsoft.com/en-us/library/ms123483%28v=sql.105%29.aspx ADOMD.NET - .NET client library for XMLA]

* [httphttps://web.archive.org/web/20100718172856/http://www.iccube.com:80/products/iccube-client-library icCube - Java XMLA Client Library (LGPL license)]

* [http://www.olap4j.org olap4j - Java OLAP API with a XML/A client implementation]<ref>{{cite web|title=OLAP4J - Online Analytical Processing for Java|url=http://drdobbs.com/database/230800051}}</ref>

* [http://agiledesignllc.com/products SSAS Entity Framework Provider - .NET LINQ client library for XMLA on top of ADOMD.NET]

Line 89:

==External links==

* [httphttps://web.archive.org/web/20060101094229/http://www.mosha.com:80/msolap/tech.htm#XMLA XMLA resources and links]

{{Data warehouse}}