Key MDX Components: Building Calculated Members, Part 1

Join Bill Pearson in the hands-on creation of dynamic calculated members. Also featured is an introduction to aggregation functions, cumulative totals, and other operations with calculated members in MDX.

Like this article? We recommend

About the Series

This is the fifth tutorial article of a series, "Introduction to
MDX." As we discussed in the first article, "Basic Concepts and
Navigation," the primary focus of this series is the creation of basic MDX
expressions and queries for use with multidimensional data sources. The lessons
in the series continually add more features to our progressively growing
familiarity with MDX, allowing us to use the MDX language in a variety of
scenarios designed to meet specific real-world needs.

The articles of the series are intended to serve as stand-alone lessons:
Although they build upon the concepts of the articles that precede them, except
where noted, each lesson will be based upon objects and steps created within it
that are independent of the steps taken in earlier sessions. For more
information on the series, as well as the hardware/software requirements to
prepare for the tutorials we will undertake, please see my initial article,
"Basic Concepts and Navigation."