Drill throughs

It is possible to execute a Drill through from a cell of a Data View when the user double-clicks on a row header (Entity member set by row) or a cell. The Drill through is executed with a selection filter applied based on the clicked Entity member or the row and column item corresponding to the clicked cell.

Drill throughs are configured in the Drill through section of the Data model.

To configure a Drill through on a row header (Entity member by row), proceed as follows:

1. Select a cell and click on the Drill anywhere icon
   

2. Click on the Drill through tab and select the Drill through you would like to be the default action when triggered by an end user
    

   If the Drill through feature is enabled from the "Drill anywhere configuration" window, a "Drill through" tab will be visible. If the Drill through feature is enabled and you would like to configure a Drill through on a row header that is not part of the list you configured as available to end users, you can do so by enabling the toggle "Show hidden" and selecting a hidden Drill through.
   
   

   If the Drill through feature is disabled, you can still apply a default Drill through by enabling the "Show hidden" toggle in the top right corner of the window and selecting a Drill through.

3. Click "APPLY" or double click on the Drill through to save the Drill through configuration.

In order to configure which Drill throughs the end user can use and see in Play mode, proceed as follows:

1. Select a cell and click on the Drill anywhere icon
   

2. From the popup window, click on the "CONFIGURE" button to open the "Drill anywhere configuration" window
   

3. Select the "Drill through" tab. Enable the toggle next to it and add the desired Drill throughs you'd like to be available to the end user below. If the toggle is not enabled, the Drill through drill down will not be available to end users in Play mode
    

4. Click "APPLY" to save and return back to the Drill anywhere window where you can now configure a default Drill through

5. Click APPLY to save the Drill through configuration.

The Drill through configuration process can also be started by double-clicking on a cell if a configuration isn't already set.

Drill through with selection filter

You can also configure a Drill through with a selection filter applied based on the row (Entity member by row) from the Layout editor. To do so, proceed as follows:

1. Select the Data View and open the Layout editor
   

2. Click on Object settings
   

3. Go to the Column appearance menu. You can also change the cell appearance by selecting one of the options listed in the dropdown menu. Click on the "CONFIGURE DRILL" button to configure a Drill through on one or more Data Blocks. Click on the "Drill through" subpage
   

4. Select a Drill through and press "APPLY" or double click on a Drill through to save and close the window
   

5. Save the Layout.

Screen selections and selections made by the user using Selector Objects (if any) also apply to data in the Drill through.

The drill feature is not supported on vertically aligned Layouts.

Read more about:

• Drill-down

• Drill-to-Screen

• Drill-Procedure