Disabling Drill-Through Functionality

How to Disable Drill-Through Functionality for a Specific Dynamic Report

You can enable or disable Drill Through functionality for specific Dynamic Reports. To do so: open a Dynamic Report, select the More drop-down menu, and click Disable Drill Through. You can enable Drill Through at any time by opening the More menu and selecting Enable Drill Through.

Important Details:

• Drill Through is enabled for the Financial reporting area only.

• Drill Through works with dimensions, report sets, attributes, attribute hierarchies, and alternate hierarchies.

• For QTD and YTD measures, drill-through data is displayed from the beginning of the period to the current period.

• Data honors the formatting from the source cell and the user locale.

• All transaction amounts are displayed in Common Currency irrespective of the reporting dimension applied on the report/source cell. Transaction data exists only for Actual Scenarios.

• Operational and Capital Planning data is displayed in Local Currency irrespective of the reporting dimension applied on the report/source cell. Operational Planning data exists only for Budget/Forecast scenarios.

• In the Operational Planning tab, when you turn off Sublines or Lines, the report is re-rendered, which removes the associated rows and columns. If both lines and sublines are turned off, data is aggregated at the Doc Ref (Template) level. If Doc Ref is turned off, data is aggregated for the unique segment and currency combination.

• In the Capital Planning tab, when you turn off Asset, the report is re-rendered, which removes the rows and columns associated, and the data is aggregated for Asset Category. If Asset and Category are turned off, data is aggregated at the Doc Ref (Template) level. If Doc Ref is turned off, data is aggregated for the unique segment and currency combination.

• When you export a drill-through report, all sources are exported to Excel. Each source on the drill-through report becomes a tab in the Excel workbook.

• Metadata is shown in exported Drill Through reports. Metadata includes the data shown in the Drill Through report, the dimensions, and the date and time of report generation.

• The Drill Through report allows a maximum of 30K rows per source.