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 ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
