Designing a Drillthrough Action using SQL Server Analysis Services (SSAS) 2012

In this article we will examine how to design a Drillthrough Action using SQL Server Analysis Services 2012.

What is a Drillthrough Action?

A Drillthrough Action provides a way to return detailed transactions based on a aggregated value, and allows for you to restrict the total number of rows returned, which helps improve query performance. For example, let's say you run a summary report for total revenues by territory. With Drillthrough enabled, you could click on a revenue data value under the desired territory column to get details of how the aggregated value is derived. The details could include: Sales Person, State, City, Sales Amount, Tax, etc.