Automatic drilling

Automatic drilling enables you to switch from the current dimension to another dimension by using system-defined commands on the shortcut menu, and it is divided into four kinds:

Drilling actions are performed on crosstabs, charts, grouped tables and banded objects, whose data are based on business/report cube or if on query, data fields of which can be converted to corresponding cube elements (see the note in Analytic reporting for details). After drilling, the new component can be analyzed in the same way as the original one.

Assume you have created a crosstab report on the report cube WorldWideSalesRC in Data Source 1 of the SampleReports catalog showing product sales information with Region as the column field, Sales Year as the row field, and Total Sales as the summary field, and applied the default style to the crosstab. The crosstab shows as follows:

We will now take the crosstab as an instance to illustrate the automatic drilling functions.

Drill-to
  1. Right-click any value of Region, APAC for example, and choose Drill To from the shortcut menu. The list of dimensions available for Drill To will appear on the submenu.

  2. Click Product Type on the submenu, then in the regenerated result, we can see that Sales Year remains the dimension for rows and Product Type becomes the dimension for columns.

  3. Repeat Steps 1 and 2 to drill the data to other dimensions. Row field can also be drilled freely.
  4. To go back to the original report, right-click any value of Product Type, choose Drill To > Region from the shortcut menu.
Drill-to-by-value
  1. Go back to the original report in the above example.
  2. Right-click the value APAC of the Region dimension, and point to Drill to By Value on the shortcut menu. A submenu for the command is displayed, which lists the same items as those of Drill To.
  3. Click Product Type too and the result will be regenerated.

    We can see that the result is different from that of drill-to. This is because that, for the drill-to-by-value action, the dimension of columns changes to Product Type by the Region value APAC. That is, on the basis of the drill-to action, a filtering action where Region = APAC is further performed, and thus the result of drill-to-by-value is generated.

    In addition, when a drill-to-by-value action is performed, the Drill Filter panel will be displayed on the left of the Page Report Studio window, which shows the dimension and the value the filter is based on.

  4. To go back to the original report, first delete the drill filter in the Drill Filter panel by clicking X next to the dimension name, then right-click any value of Product Type and click Drill To > Region from the shortcut menu.
Drill-down

Drill-down actions are based on predefined business/report cube hierarchies. The report cube WorldWideSalesRC contains a hierarchy Geography, which allows you to drill a dimension (corresponding to a high level) down to the one-level-lower dimension.

  1. Go back to the original report in the above example, right-click the value APAC, on the shortcut menu, point to Drill Down, and we can see that Territory is listed as the submenu item.

  2. Click Territory to see the result. It displays the data about territories in the Asia Pacific region.

  3. The one-level-lower dimension for Territory defined in the hierarchy is Country. Now click Asia directly and JReport will also drill it down to Country.

    After these two drill-down actions, we can see two filters are added in the Drill Filter panel, Region = APAC and Territory = Asia.

    This is because, when you perform a drill-down action, a filter will be created based on the value you click on. In this example, we first click on the APAC region, so JReport drills this region one-level down to display territories in APAC, and thus the filter Region = APAC is created. If you want all data in the one-level-lower dimension to be displayed when you drill down a dimension, you can remove the corresponding filter from the Drill Filter panel.

Drill-up

Drill-up actions allow you to drill a dimension (corresponding to a low level) up to the one-level-higher dimension.

  1. Based on the report result after drill-down, right-click any value of Country, China for example, on the shortcut menu, point to Drill Up, and we can see that Territory is listed as the submenu item.

  2. Click Territory to see the result. The dimension is drilled one level up. Territory is now the dimension for columns.

  3. The one-level-higher dimension for Territory defined in the hierarchy is Region. Now right-click any value of Territory, Asia for example, on the shortcut menu, point to Drill Up and click Region, JReport will drill it up to Region.

Notes: