Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Introduction

In Part 2 of this series, "Intermediate MDX Concepts, Part 1," we turned our focus to returning values from a multidimensional cube. We created calculated measures that referenced current members, and explored more advanced uses of calculated members; using them, in turn, to refer to current measures. Throughout the lesson, we expanded a growing body of MDX concepts and terminology to include the retrieval of values.

We briefly explored parts of the MDX system of notation relevant to the objectives of the lesson, centering largely on the concepts of specifying dimensions in MDX expressions. We examined practical uses for MDX expressions in an exercise that integrated many of the concepts we've discussed into a single, practical example. As part of the exercise, we took a brief look at string formatting and other presentation nuances.

In this tutorial, we'll expand on the intermediate topics introduced previously to do the following:

  • Use expressions to further leverage the hierarchical relationships that exist in an OLAP cube

  • Handle empty-member considerations

  • Retrieve data from a secondary OLAP cube

  • Build the concept of time into expression designs

  • Incorporate support for time-based analysis with MDX functions

  • Generate variance calculations

  • + Share This
  • 🔖 Save To Your Account