|
MDX Tutorial
MDX Tutorial - MDX Definition
- MDX stands for Multi Dimensional Expressions. This is a Microsoft
proprietary language used to define and manipulate multidimensional
cubes.
- MDX is similar to SQL , but not an extension of the SQL language.
- Typical MDX query has a SELECT clause, a FROM clause, and WHERE
clause (filter).
- MDX expressions are used to extract required portions of data from
a cube for analysis.
- MDX also supplies a robust set of functions for the manipulation
of retrieved data as well as the ability to extend MDX with
user-defined functions.
- MDX, like SQL, provides data definition language (DDL) syntax for
managing data structures.
- There are MDX commands for creating and deleting cubes,
dimensions, measures, and their subordinate objects.
This MDX Tutorial is for educational purposes only. For updates to
this MDX Tutorial page, send an email to info at freedatawarehouse.com.
|
|