Using Drill Through in Dynamic Reports
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Using Drill Through in Dynamic Reports

  • Dark
    Light
  • PDF

Article summary

Drill through in Reports

Click the drill through icon on the top menu to view the drill through report.

Note:
The Drill Through icon is enabled only if Drill Through is enabled for the Dynamic report.

The icon is visible in the toolbar across all Dynamic Reports on Financial reporting area where Drill Through is enabled in the report. Additionally, the icon is enabled only for those cells where drill through is applicable. It is disabled for header, excel, row title, Insert Formula, formula exception, and advanced formula cells.

You can view the drill through report in the following ways:

  • Click the Drill Through icon.

  • Double click the cell on the grid.

  • Drill down – hierarchical drill - expand a line on the report to see data for lower level members in the main/alternate/attribute hierarchy

  • Drill through – drill on a number into the transactional data or translational details that were loaded with Data Load Rules

In Practice: Drill Down

Time dimension data - For example, if you expand 2017, you can view data for the 4 quarters associated with 2017. If you expand each quarter you can view data for each month.

Variable data - If you expand a variable, such as @CURYR@, you can view data for the 4 quarters associated with the current year variable. You can expand the quarters to view data for each month.

Simple Rule in a Report Set

- For example, you define a line as follows:

sum({4010 - Gross Sales , 4020 - Royalties , 4030 - Indirect Sales , 4100 - Intercompany Sales - Mfg})

You can drill down to view data for 4010, 4020, 4030, and 4100.

Or, let's say you define a line as follows:

sum({@CURMTH@ , @CURMTH-1@ , @CURMTH-2@ , @CURMTH-3@ , @CURMTH-4@})

You can drill down to view data for the current month and the previous 4 months.

Note:
A rule represents data elements in the cube similar to rules created in Excel (similar to cells, rows, and columns). Report Sets are built using rules.

In Practice: Drill Through

You have Net Income on the row and Aug-17 on the column. Click the number and drill to the daily transactional or translations data. This works only if the data was loaded with Data Load Rules.

You have Net Income on the row and @CURMTH@ on the column. Click the number and you can drill to the daily transactional or translations data if loaded via Data Load Rules.

You have Net Income on the row and sum({@CURMTH@ , @CURMTH-1@ , @CURMTH-2@ , @CURMTH-3@ , @CURMTH-4@}). When you drill through, you can view the transactional or translations data for the current month and the previous 4 months.

You have ([Account].&[1068],[Department]. &[101],[Project].&[565]) on the row defined using the Multiple dimension option in Report Sets and MTD on the column. You can drill to the daily transactional or translations data.

Drill-through displays values from the beginning of the year to the current period when YTD or QTD are applied.

Values displayed in the drill-through pop-up window are applicable for all periods, from either the beginning of the current fiscal year or the period selected during report design. For example, if current month is set to September, drill-through displays the values from January until September if YTD is the Measure applied.

The columns for transactional or translation drill through data can be sorted in the pop-up window.

Note:
Drill through will work if both the row and column use simple rule definitions. If multi-dimensional rules are defined using the Advanced Rule page, the system will not automatically translate the rule to a simple rule definition, and drill through is not opened until you manually convert the advanced rules into simple rules.

To know more about the drill through capabilities, refer to Enhanced Drill Through topic.<>


Was this article helpful?