Export a Drill Through Result

By default, the Drillthrough Result window displays the first 100 records of the result. However, if you want to analyze the complete result set of the drill through action, you can export all the results to a .CSV file.

Note: The drill through export result depends on the maximum number of rows defined in DefaultDrillthroughMaxRows in the OLAP database. The default value for this property is 10000 (rows). For more information, see the MSDN documentation.

Steps

Access the Drillthrough Result window.
Select .

The .CSV file appears.