O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hierarchical Functions in MDX

One useful feature of OLAP cubes is their ability to use hierarchies to retrieve result sets by selecting a specific dimension member (a specific market, product group, or time element such as a quarter or month) and drilling down (or up) to see all the child (or parent) data. After you’ve established hierarchies in your OLAP dimensions, you can use several MDX functions to navigate these hierarchies. Let’s take a look at some examples.

For starters, you can use the MDX Children function to retrieve all records for the next level down in a hierarchy, based on a specific dimension member. For example, you can retrieve sales for all the subcategories under the category of Bikes with the following query. The results are ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required