Choose Index below for a list of all words and phrases defined in this glossary.
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: dqglossary@grcdi.nl