Drill through cells to see detailed data
About this task
Watch this video to see how you can perform a drill through in Planning Analytics for Microsoft Excel:
If your TM1 modeler has defined drill processes or drill assignment rules for a TM1 cube, view, or relational table that you're working with, you can drill through certain cells in your report. The drill through feature provides detailed data on the cell, and shows you information from the data source. You can drill through cells in Exploration Views, Custom Reports, Quick Reports, Dynamic Reports, andUniversal Reports.
In Universal Reports, there is no delay before the drill through feature is enabled for a valid cell, whereas in other reporting modes, there is a short delay before the Drill Through icon is enabled.
Depending on the data source, you can perform either a cube drill through or a relational drill through.
![Cube drill through](images/pax_dt_cubeview.jpg)
![Drill through table view](images/pax_dt_table.jpg)
Procedure
-
Highlight a cell and check to see whether the cell can be drilled through. In the IBM Planning
Analytics ribbon, in the data section, there is an icon for
Drill Through. If the Drill Through icon is enabled, you can drill through the highlighted cell.
- Click the Drill Through icon
.
- Click the data source that you want to view in more detail.
Results
![Setting the member count](images/drillthrough_icon.gif)