MDX Function List

  New Information - SQL Server 2000 SP3.

This topic contains lists of the Multidimensional Expressions (MDX) functions in Microsoft® SQL Server™ 2000 Analysis Services. You can use these lists to find functions by their category of return value, or you can select a function by name from the alphabetical list in the table of contents.

Samples Used in Examples

For many expression examples in the following topics, SampleSet is defined as:

{USA, Buffalo, France, NYC, London, California, LA, Nice, UK, Paris}

The following table lists sales data for each member of the set.

MDX Function Groups

The following tables list the MDX functions grouped by their return value categories. You can use the links in the tables to jump to the function reference topics.

Array Functions