About the Drillthrough Feature

In a Metric View, you can drill through certain values in a table or a graph to view the underlying intersection data or source data. The intersection data displayed on the drill through is composed of data that is associated with the end value.

For example, suppose you have a Metric View that measures the total number of work orders over time. In this case, you could drill through the total number of work orders value for 2005 and view the underlying data that is associated with the work order, such as the equipment to which the work order was assigned, the department in which the equipment was located, and the manufacturer of the equipment to which the work order was assigned. Drill through data provides you with a more complete understanding of the Metric View.

The availability of the Drillthrough feature and the data that is displayed is determined by how the associated cube has been configured in Analysis Services.