# Functions (MDX Syntax)

**SQL Server 2008 R2**

Multidimensional Expressions (MDX) has several categories of intrinsic functions to perform certain operations. The following table lists the function categories that are available in MDX.

Note |
---|

For more information about individual functions, see MDX Function Reference (MDX). |

Function Category | Description |
---|---|

Array functions | Provide arrays for use in stored procedures. For more information, see Using Stored Procedures (MDX). |

Dimension functions | Return a reference to a dimension from a hierarchy, level, or member. For more information, see Using Dimension, Hierarchy, and Level Functions. |

Hierarchy functions | Return a reference to a hierarchy from a level or member. For more information, see Using Dimension, Hierarchy, and Level Functions. |

Level functions | Return a reference to a level from a member, dimension, hierarchy, or from a string expression. For more information, see Using Dimension, Hierarchy, and Level Functions. |

Logical functions | Perform logical operations and comparisons on objects and expressions. For more information, see Using Logical Functions. |

Member functions | Return a reference to a member from other objects or from a string expression. For more information, see Using Member Functions. |

Numeric functions | Perform mathematical and statistical functions on objects and expressions. For more information, see Using Mathematical Functions. |

Set functions | Return a reference to a set from other objects or from a string expression. For more information, see Using Set Functions. |

String functions | Return string values from other objects or from the server. For more information, see Using String Functions. |

Tuple functions | Return a reference to a tuple from a set or from a string expression. For more information, see Using Tuple Functions. |