Cascading drill through

If your TM1 modeler defined multiple levels of drill processes or drill assignment rules for a TM1 cube, view, or relational table that you're working with, you can successively drill through multiple levels in your report.

About this task

You can successively drill through multiple levels from the Drill Through Viewer or the Cube Viewer.

Procedure

  1. Open the Drill Through Viewer or the Cube Viewer.
  2. Right-click a drill through capable cell.
    Figure 1. Drill through menu
    Drill through menu
  3. Click Drill through.
    Note: If the Drill through option is disabled, the cell that you right-clicked on does not have drill processes or drill assignment rules set for it.
  4. Click the drill process that you want to use.
    Figure 2. Drill through process
    Drill through process

Results

An additional Drill Through Viewer appears.
Figure 3. Multiple Drill Through Viewers
Multiple Drill Through Viewers

What to do next

If your TM1 modeler has more levels defined, you can repeat these steps in new Drill Through Viewers to continue drilling. You can also generate reports from any of the Drill Through Viewers.