- 3 Minutes to read
- Print
- DarkLight
- PDF
Using Drill Through in Dynamic Reports
- 3 Minutes to read
- Print
- DarkLight
- PDF
Drill through in Reports
Click the drill through icon on the top menu to view the drill through 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.
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.
To know more about the drill through capabilities, refer to Enhanced Drill Through topic.<>