O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, 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 a 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 to the levels we need to. This cube data is typically aggregated at different levels.

There is another side to the story. Users occasionally want to see every single detail about an aggregated value represented in a single cell in pivot. This information originates from a series of fact tables or individual transactions in the relational database. So, we might think that if we want to see the transactions that give a certain measure, we would look for them in the relational data warehouse. However, we can find these ...

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