MDX Essentials: Structure of the MDX Data Model

In this article, we introduced the MDX data model and its most basic components, namely tuples, axes, and sets. We focused on the composition and uses of tuples, axes and sets, and provided hands-on exposure to these building blocks. After discussing each of the three components, we emphasized rules of syntax that related to each, providing a basis to build upon as we progress through the series. Finally, we worked practice exercises to demonstrate tangible results and to reinforce our discussions with examples.

In our next lesson, MDX Operators and Functions: The Basics, we will introduce additional ways to construct tuples and sets, taking up first the most basic of the components involved. The operators we explore in this lesson will include curled braces "{ }", commas "," and colons ";", and members. With each or the operators, and especially with the members operator, we will illustrate the uses and options that are available to us in constructing queries that are basic in nature.

See All Articles by Columnist William E. Pearson, III