MicroStrategy ONE

MDX

MDX—which stands for MultiDimensional eXpressions—is a query language for OLAP (Online analytical processing) databases, just as SQL is a query language for relational databases. OLAP databases use a data model in which multidimensional data is stored in OLAP cubes. With the MDX language, you can quickly execute complex queries and manipulate the data stored in OLAP cubes.

MicroStrategy OLAP Services, which extends the capability and functionality of MicroStrategy Intelligence Server, supports the creation and manipulation of multidimensional OLAP cubes (sets of data) using MDX.

The MicroStrategy SDK has a specific method for connecting to OLAP cubes and accessing attributes and metrics. For an annotated code sample that illustrates how to do this, refer to Accessing MSAS Cube Objects (Attributes and Metrics).