Choose Index below for a list of all words and phrases defined in this glossary.

Multidimensional Expressions (MDX)

index | Index

Multidimensional Expressions (MDX) - definition(s)

MDX (Multidimensional Expressions) - The querying language for OLAP cubes.

MDX has some similarities to SQL, but has many unique features. The following query returns a cellset with the names of the store regions  on the columns, the names of product families on the rows, and the profit displayed in the cells:

   select [Stores].[Region].Members on columns, [Products].{Product Family].Members on rows from SalesCube where ([Measures].[Profit])

[Category=Data Warehousing ]

Source: SDG Computing Inc., 09 May 2010 10:13:41, SDG Computing, now offline





Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: