Data Warehouse Developer Interview Question:

Do you know what is XMLA?

Submitted by: Muhammad

☛ XMLA is XML for Analysis which can be considered as a standard for accessing data in OLAP, data mining or data sources on the internet. It is Simple Object Access Protocol.XMLA uses ‘discover' and ‘Execute' methods. Discover fetches information from the internet while Execute allows the applications to execute against the data sources.
☛ XMLA is an industry standard for accessing data in analytical systems, such as OLAP. It is based on XML, SOAP and HTTP.
☛ 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
Submitted by: Muhammad