MultiDimensional eXpressions

MultiDimensional eXpressions is a query language created in 1997 by Mosha Pasumansky.

#1728on PLDB

27Years Old

Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes. It is also a calculation language, with syntax similar to spreadsheet formulas.. Read more on Wikipedia...

Tags: queryLanguage
Early development of MultiDimensional eXpressions happened in Microsoft

Example from the web:

SELECT
   { [Measures].[Store Sales] } ON COLUMNS,
   { [Date].[2002], [Date].[2003] } ON ROWS
FROM Sales
WHERE ( [Store].[USA].[CA] )