You can use the Drillthrough feature to view the relational source data that contributes to the value of a cell within the grid. This is useful in situations where you wish to have insight into the source records that accumulate to the cell value, for example, when verifying the correctness of a cell value.
Getting Drillthrough Results
To view the drillthrough results for a cell, right click the cell and select Drillthrough... from the context menu.
Drilling through will produce results like the following:
The drillthrough results window will contain a grid with the resulting source records. Each table column in the source is represented by a column in the grid. The results can be sorted ascending or descending by clicking the column header once or twice. Note that possibly not all source columns are displayed in the grid This depends on how this has been configured on the server (see below).
To help analyzing the drillthrough results, you can:
| 1. | Sort the results by clicking on the column header |
| 2. | Group the results by column value by clicking on the  button in the toolbar and dragging the columns which you want to group by to the group by box at the top of the dialog. You can group by multiple columns. See the figure below. |
| 3. | Excel-like auto filter the results, by clicking on the filter icon in the column header and selecting the entry to filter on. |
The drillthrough results can be exported to Excel or Html. To do this, click the 
button for Excel or the 
button for Html.
By pressing the 
button, you can add a total summary statistic to all numeric columns.
Even if drillthrough is enabled as stated above, it isn't possible in all situations, the following limitations apply:
| • | Drillthrough is not supported for cells that have values based on expressions such as calculated member cells or ones that are associated with custom member formulas |
| • | Drillthrough permissions are granted through membership in cube roles. The only end users who can drill through are those in cube roles that have been granted this ability |
| • | Drillthrough results can only be retrieved if background hierarchies, i.e. hierarchies not present on the columns or rows, have at most one member selected. If a background hierarchy has more than one member selected, the drillthrough will be performed with only the first member in the selection, thus probably returning more results than expected. If this is the case, a warning will be displayed as shown below: |
Limiting the number of records returned
A drillthrough can possibly return a very large amount of records. This could require waiting a substantial amount of time for all records to be retrieved. For this reason, by default only the first 1000 records are retrieved. You can change how many records are retrieved by changing the amount in the configuration file (see the DWE Administrators guide for this) or by changing the Drillthrough limit value in the connection properties.
Note: by setting this value to 0, all records will be retrieved.
To configure drilling through on the server, both for 2000 and 2005, please see the corresponding documentation here.
Analysis Services 2000
When working with Analysis Services 2000, to access the source of a cell's drillthrough data, the data source of the corresponding cube is used, as defined in Analysis Manager. If this data source uses an ODBC DSN, then this DSN (and corresponding ODBC driver) must also be present on the client machine. If the data source uses OLE DB, the corresponding OLE DB provider must be present on the client machine, and the target database must be reachable from the client. When working with Analysis Services 2005 this isn't necessary.