Thursday, February 13, 2014

What is MDX, DMX and XMLA - SSAS Languages

These are just definitions and very basic information. You might see that there are 3 kind of language available to work on SSAS via SQL Server Management Studio. They are DMX, MDX and XMLA.

MDX: Multidimensional Expressions, this language is useful to retrieve data from SSAS objects same as T-SQL or SQL in Relational Databases.


DMX: Data Mining Extensions, this language is used for SSAS object, but especially for data mining structure. DMX statements are used to create process, delete, copy, browse, and predict against data mining models.


XMLA: XML for Analysis is a Simple Object Access protocol (SOAP) - based XML protocol, designed specifically for universal data access to any standard multidimensional data source residing on the Web. Microsoft SQL Server Analysis Services implements XMLA per the XMLA 1.1 specification. XMLA is the native protocol for SSAS, used for all interaction between a client application and instance of Analysis Service. Both Analysis Management Objects (AMO) and ADOMD.NET use the XMLA protocol when communicating with an instance of Analysis Service. This XMLA Queries are mainly used for Administrative purposes such as taking backup, moving data, etc.

Cheers!

6 comments:

  1. "hello Umashanthan,
    awesome your explanation regarding What is MDX, DMX and XMLA - SSAS Languages

    ReplyDelete
  2. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training

    ReplyDelete
  3. Thanks for sharing a very informative post, I studied the Step By Step SSAS Tutorial, and this post is also beneficial for me .

    ReplyDelete