MDX Functions in Analysis Services

Analysis Services

Analysis Services

MDX Functions in Analysis Services

Microsoft® SQL Server™ 2000 Analysis Services provides for the use of functions in Multidimensional Expressions (MDX) syntax. Functions can be used in any valid MDX statement, and are often used in queries, calculated members, and custom rollup definitions. There are three types of functions in MDX, and each is described in a separate topic. The following table lists, describes, and provides links to each topic.

Topic Description
MDX Function Reference Provides a list of functions intrinsic to MDX, including syntax and examples.
Registered Function Libraries Describes the use of external function libraries, such as the Microsoft Excel worksheet library and the Microsoft Visual Basic® for Applications Expression Services library, in MDX expressions.