XML for Analysis
XMLA specification differentiates between XMLA providers and XMLA consumers. XMLA data from XMLA providers may be edited by any XMLA consumer, for example in a front-end, for further analysis and reporting. This ensures simple integration of databases and clients from various manufacturers.
XMLA providers are usually multidimensional databases such as:
- Infor PM OLAP / Alea
- Hyperion Essbase
- LucaNet.Financial OLAP Server
- Microsoft SQL Server Analysis Services
- Mondrian OLAP Server
- Palo OLAP Server
XMLA MDX (Multidimensional Expressions) is used as the query lanuage. MDX is similar to SQL and is optimised for query of multidimensional data.