The "Drillthrough" widget returns all the underlying facts (also referred to as records or contributors) that contributed to a specific cube location. See also: What is Drillthrough?.
The Drillthrough feature is available in Pivot Tables and Tabular Views via context menus. A drillthrough can be performed on any numerical cells as long as the underlying measure is not a calculated measure published in the cube.
The Drillthrough opens in a new page:
You can click
+ to change the columns selection:
The list of columns you can add from a Drillthrough widget may be different from the list of columns available to build Pivot Tables or Tabular Views. The cube data structure often acts as a semantic layer on top of the raw data, reflecting the user perspective of the data. Liaise with your product development team if you have questions or requirements concerning the list of columns available in a Drillthrough.
The Drillthrough widget also supports:
The Drillthrough widget uses MDX to query ActivePivot. Advanced users who are interested in the syntax may wish to refer to the official drillthrough documentation by Microsoft.