SQL SERVER – Languages for BI – MDX, DMX, XMLA

Today, we have a very basic thing to go over. Few days back, I was discussing with one of my friends regarding BI. He told me that he knows that BI stands for Business Intelligence but he would like to know what languages BI uses to achieve the goal. The reason I found this question very interesting was because     I was asked the same question two weeks back at TechEd on Road Ahmedabad. I had promised one of the attendees that I will reply to his question soon. This question, which my friend asked recently, reminded me of the same. Let us go over the languages of BI very quickly. Again, these are just definitions and there is much more to learn. Moreover, to master each language it may take years.

MDX – Multidimensional Expressions. This language is used for retrieving data from SSAS cubes. It looks very similar to T-SQL, but it is very different in the areas of conceptualization and implementations.

DMX – Data Mining Extensions. This is again used for SSAS but rather than cubes it is used for data mining structures. This language is more complicated than MDX. Microsoft has provided lots of wizards in its BI tools, which further reduced experts for learning this language which deals with data mining structures.

XMLA – XML for Analysis. This is mainly used for SSAS administrative tasks. It is quite commonly used in administration tasks such as backup or restore database, copy and move database or learning meta data information. Again, MS BI tools provide lots of wizards for the same.

After writing the above definitions, I feel my information is incomplete as these are just very basic information and do not provide much value. I will cover interesting aspects of these languages in near future. In SQL Server Management Studio, you can write the queries in the desired languages using top menu bar.

SQL SERVER - Languages for BI - MDX, DMX, XMLA bilang

Reference : Pinal Dave (https://blog.sqlauthority.com)

Business Intelligence, SQL Server
Previous Post
SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
Next Post
SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009

Related Posts

5 Comments. Leave new

  • Few more languages:
    Rdl (Report Definition Language) for Reporting,

  • Sunil Shinde
    July 9, 2009 2:55 pm

    Hi Pinal ,

    Can u plz give one sample illustrating DMX ?


  • Mr Dave,

    Maybe you could reword the last sentence about DMX as such:
    “… which further reduces need for experts to learn this language which deals with data mining structures.”

  • hello pinal i forget one table name but i remember that this table has only one record and i even know that employee id (of single record of table) can i search the table name on the basis of this.


Leave a Reply