A TM1 modeler can define drill processes and drill assignment rules for a data source. If
the TM1 cube, view, or relational table that you are working on contains drill processes or drill
assignment rules, you can drill through certain cells to detailed data.
About this task
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.
Note: Non-admin users require the installation of IBM® Planning
Analytics version 2.0.3 IF4 or later to use the drill-through
feature.
Depending on the data source, you can perform either a cube drill
through or a relational drill through.
A cube
drill through is a drill through on a TM1 cube or TM1 view data source. The Drill
Through Viewer opens when you drill through a cube or view. The Drill Through Viewer is
interactive.Figure 1. Cube drill through
A relational drill through is a drill
through on a relational table, such as an ODBC or flat file data source. A table viewer opens when
you drill through a relational table. The table viewer is non-interactive.Figure 2. Relational drill through
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
A drill through view of the data source for the selected cell
appears.
.
