Defining drillthrough actions

Drillthrough is a very frequently used functionality that allows the examination of detailed level data values. Earlier versions of Analysis Services allowed for executing queries against the relational data source, thereby enabling leaf-level data to remain in the relational format. Unfortunately, this often led to poor performance, which could not be controlled from SSAS. Starting with SSAS 2005, drillthrough only works within the cube space and requires any detailed data to be imported into the MOLAP storage. Clearly the major drawback of this approach is that we might have to build huge dimensions in order to expose data at the transaction level. An alternative approach is to implement an Excel macro to run a ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.