This tutorial walks you through some of the fundament MDX concepts, before taking a simple MDX statement and progressively building on it to produce a more complex statement. As you move though each step you will learn progressively more interesting techniques. By the end of the tutorial you will have a sound knowledge of the fundaments of MDX plus some of the more advanced principles.
| Cube Overview | This article describes the structure of the cube used in the tutorial including its dimensions, levels and properties. |
| MDX Concepts | This article describes the basic concepts of OLAP cubes and MDX statements. |
| Simple MDX | This article uses a simple MDX statement to explain the basic structure of MDX. |
| Simple MDX Functions | This article expands on the previous introducing basic MDX functions. |
| Specifying More Complex Tuples In An Axes | This article takes the simple statement in the previous section and enhances it by adding more complex axes definitions. It also introduces further functions, and methods for including total rows and columns in an MDX statement. |
| Calculated Members | This article introduces the concept of calculated members. |
| Calculated Members Continued | Calculated members are expanded upon and several new key words and functions are introduced. |
| Exercise 1 - Overtime Report | This article contains an exercise that uses the techniques introduced in the previous articles. |
Last
Reviewed: Sunday, 22 February 2004 12:37:39 p.m.
Copyright message...