- XML for Analysis
XML for Analysis (abbreviated as XMLA) is the industry standard for data access in analytical systems, such as
OLAPand Data Mining. XMLA is based on other industry standards such as XML, SOAPand HTTP. XMLA is maintained by "XMLA Council" with Microsoft, Hyperion and SAS being the official XMLA Council founder members. [cite web|title=What is XMLA?|url=http://www.xmlforanalysis.com/index.htm]
The XMLA specification was first proposed by
Microsoftas a successor for OLE DB for OLAP (ODBO)in April 2000. By January 2001 it was joined by 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 SASjoined Microsoft and Hyperion as founding member of XMLA Council. [cite web|title=XML for Analysis gathers steam|url=http://www.olapreport.com/Comment_APIs.htm] With time, more than 25 companies joined with their support for the standard.
XMLA consists of only two
SOAPmethods. [cite web|title=XML for Analysis Specification|url=http://msdn.microsoft.com/en-us/library/ms977626.aspx] It was designed in such a way to preserve simplicity.
Execute method has two parameters:
The result of Execute command could be "Multidimensional Dataset" or "Tabular Rowset".
Discover method was designed to model all the discovery methods possible in
OLEDBincluding various schema rowset, properties, keywords etc. Discover method allows to specify what needs to be discovered, the possible restrictions and properties.The result of Discover method is a rowset.
XMLA specifies MDXML as the query language. In the XMLA 1.1 version, the only construct in MDXML is an MDX statement enclosed in the
tag. [cite web|title=MDX / mdXML|url=http://www.xmlforanalysis.com/mdx.htm]
Below is an example of XMLA Execute request with MDX query in command.
">"> ">"> SELECT Measures.MEMBERS ON COLUMNS FROM Sales FoodMart Multidimensional TupleFormat
XMLA has a notion of "session state". It is maintained through predefined "
* BeginSession - to begin a new session
* EndSession - to end existing session
* UseSession - to use existing session. SessionId attribute previously returned for BeginSession should be used.
Products which support XMLA fall into two categories:
* XMLA Providers - these products provide XMLA service. Typically these are server or middle tier products
* XMLA Consumers - these products can connect to XMLA Providers and consume XMLA. Typically these are client/UI products
* [http://knol.google.com/k/igor-krupitsky/xmla-consumers XMLA Consumers]
* [http://www.mosha.com/msolap/tech.htm#XMLA XMLA resources and links]
* [http://www.xmlforanalysis.com XMLA Information]
Wikimedia Foundation. 2010.
Look at other dictionaries:
XML Schema Language Comparison — An XML schema is a description of a type of XML document, typically expressed in terms of constraints on the structure and content of documents of that type, above and beyond the basic syntax constraints imposed by XML itself. There are several… … Wikipedia
XML schema — An XML schema is a description of a type of XML document, typically expressed in terms of constraints on the structure and content of documents of that type, above and beyond the basic syntactical constraints imposed by XML itself. An XML schema… … Wikipedia
XML appliance — An XML appliance is a separate computer system with deliberately narrow functionality that exchanges XML messages with other computer systems. XML appliances secure, accelerate and route XML so enterprises can cost effectively realize its full… … Wikipedia
Microsoft Analysis Services — Microsoft SQL Server Analysis Services (SSAS) Developer(s) Microsoft Stable release Analysis Services 2008 R2 / December 21, 2010; 10 months ago … Wikipedia
Microsoft Analysis Services — Тип OLAP, Интеллектуальный анализ данных Разработчик … Википедия
List of XML markup languages — This page aims to list articles related XML markup languages. This is so that those interested in the subject can monitor changes to the pages by clicking on Related changes in the sidebar and on the bottom of the page.The list is not necessarily … Wikipedia
OLE DB for OLAP (ODBO) — OLE DB for OLAP (abbreviated ODBO) is a Microsoft published specification and an industry standard for multi dimensional data processing. ODBO is the standard application programming interface (API) for exchanging metadata and data between an… … Wikipedia
OLE DB for OLAP — (abbreviated ODBO) is a Microsoft published specification and an industry standard for multi dimensional data processing. ODBO is the standard application programming interface (API) for exchanging metadata and data between an OLAP server and a… … Wikipedia
Centre for the Analysis of Social Exclusion — The Centre for Analysis of Social Exclusion (CASE) is a British research institute at the Suntory and Toyota International Centres for Economic and Related Disciplines (STICERD) at the London School of Economics.It lists its core research areas… … Wikipedia
List of tools for static code analysis — This is a list of significant tools for static code analysis.Historical products* Lint the original static code analyzer of C code.Open source or Noncommercial products .NET (C#, VB.NET and all .NET compatible languages) *… … Wikipedia