O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

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

Performing custom drillthrough

Multidimensional database systems like Analysis Services naturally support the top-down analysis approach. Data can be browsed using multilevel hierarchies, starting from the top level and descending down as the circumstances require. The whole process is backed up with aggregates, which are mostly calculated for upper levels, levels with fewer members, although this can be influenced in the aggregation designed.

There is another side of the story. Users occasionally want to see every single detail about an aggregated value represented in a single cell in pivot. The mechanism that supports this is the drillthrough mechanism.

Drillthrough can either be issued as a standalone command, or it can be predefined as a cube-based ...

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