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 query against the relational data source if the user needs to see such data.
How to do it...
Let us define a drillthrough action as follows:
Choose New Drillthrough Action after right-clicking on the SSDT Action Organizer within the Actions tab. Supply...
