Drilling Through Reporting on Consolidation Data

Drill Through Reporting on Consolidation Data

Drill through to source information on Consolidation data. Data imported from a general ledger or adjustments made using journals or the transformations of data by the Consolidation process can be drilled into using Dynamic Report Drill Through.

When you drill through in a Dynamic Report, you will see a tab called Consolidation as shown below.

As shown in the image above, the default columns displayed for Consolidation include the Chart of Accounts segment combination (in this example; Account, Company, Intercompany, Department, Product, Project), Measure, Reporting, Type, Doc Ref, Line, Currency, Month and Amount.

Cells in the Type column populate from the following; Standard Journals, Dynamic Journals, Non-Controlling Interest Calculations, Reclassifications, Eliminations, Consolidation Process, and MSOB (Multiple Set of Books) Calculations.

Cells in the Doc Ref column populate with labels that correspond with the Type column. For example in the image below, Doc Ref represents the name of a Standard Journal, which is why the Type is Standard Journal.

The Standard Journals in this case are set up against the US Co 1 company as shown below in the Member Selector screen of the Consolidation Control Panel.

Similarly, if the Type is Elimination, then Doc Ref references the Elimination entry for the account and company.

Cells in the Line column populate for Standard Journals, Dynamic Journals, and Non-Controlling Interest Types. The cells in this column will be empty for all other Types. If two Lines with the same Line Name/Description are posted from a single Journal for a given segment combination, their values are aggregated in the drill-through report.

Turn ON/OFF is enabled for Type and Doc Ref. If turned OFF, data is aggregated for unique segment and currency combinations across all journals and the Consolidation Process.

Reporting Dimension Filters on the Consolidation Tab

You can filter Drill Through data based on Reporting dimensions for the Consolidation tab.
 
For example, If the Reporting dimension is mapped in the report and you filter data based on the Adjustments member, then data related only to the Adjustments member is displayed in the Drill Through report as shown in the image below.

The Drill Through report is shown in the image below.