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.
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!
"hello Umashanthan,
ReplyDeleteawesome your explanation regarding What is MDX, DMX and XMLA - SSAS Languages
Nice post, check it once through MSBI Online Training Hyderabad
ReplyDeletecheck it once through MSBI Online Training Bangalore
ReplyDeleteThrough 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
ReplyDeleteThanks.
ReplyDeletepower bi training
Thanks for sharing a very informative post, I studied the Step By Step SSAS Tutorial, and this post is also beneficial for me .
ReplyDelete