multidimensional expressions (MDX)

multidimensional expressions (MDX)

Multidimensional eXpressions is a language for expressing analytical queries. MDX is an extension to the SQL language which Microsoft utilizes to query and script access to multidimensional data. You can use MDX queries to get at data stored in a SQL Server Analysis Server cube by bringing back facts based on dimensions An MDX expression returns a multi-dimensional result set (dataset) that consists of axis data and cell data. expression syntax for querying multidimensional data in Microsoft SQL Server OLAP Services. Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases MDX is a query language that is used to interact and perform tasks with multidimensional databses (also called: OLAP Cubes). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of Multidimensional Databases. A Multidimensional Database (also called: OLAP Cubes) is a method of storing data in a multidimensional form, generally for reporting purposes. In Multidimensional databases, data (measures) are categorized by Dimensions. Multidimensional databases are often pre-summarized across dimensions to drastically improve query time, over traditional Relational Databases. Microsoft's Multidimensional Database product is called SQL Server Analysis Services. In some ways we can draw an analogy between MDX and SQL. SQL is there to manipulate data; MDX is there to manipulate information. MDX started in a small company (Panorama) which was acquired by Microsoft, and hence it was seen for a while as a Microsoft standard. However, Microsoft relinquished control to a standards body and now MDX was adopted by Hyperion, which is now owned by Oracle. So MDX is now a non-proprietary standard.

This was first published in April 2012

Glossary

'multidimensional expressions (MDX)' is part of the:

View All Definitions

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close