Exploring MDX (Multi Dimensional Expression) in SQL Server Analysis Services
Introduction to MDX
Multi Dimensional eXpression (MDX) is a language created to allow the users to work with multi dimensional data in Microsoft SQL Server Analysis Services. It works as a query language with OLAP (Online Analytical Processing) cubes. We can also use it to create calculated members or use the various functions provided which can be used to query data.
Differences in SQL and MDX
If you are a little familiar with SQL (Structured Query Language), you may feel there is some similarity with MDX in some aspects. The SELECT clause, FROM clause and WHILE clause are similar with SQL and MDX. MDX provides various ways with which a cube can be queried - it provides different functions.
With MDX we can even create, modify and delete cubes if required.