Extended drillback is an advanced model-level setting in Anaplan Financial Consolidation and Reporting that creates a granular, side-by-side audit trail between your staging tables and consolidated fact tables. When enabled, Extended drillback lets you to inspect individual data points, inspect historical writebacks, and verify mapping and source origins without leaving the reporting environment.
In financial consolidation and close cycles, you need data integrity, auditability, and traceability. When consolidated balances raise questions during internal reviews or external audits, finance teams must quickly determine whether an adjustment came from the general ledger (GL) or was manually modified via a report writeback.
For example, during the Q1 month-end close, you import trial balances from your general ledger into your consolidation model. In a report, you see an $800 balance from the general ledger. You can right-click the cell, select Drillthrough, set a row limit, and select OK to see a detailed comparison showing the Source Values from your staging table alongside the final information in the fact table for Import data and Writeback.
Examples
Note:Extended drillback is designed for deep transaction traceability. Unlike standard cell drilldown, which only navigates dimensions, Extended drillback reveals the source of data changes.
Key capabilities and captured metadata
Extended drillback moves beyond standard cell-level drilldown by capturing an event-driven transaction log for data changes. For any target cell, Extended drillback records and displays:
Source and fact value comparison: The original imported value (from the staging table) compared with the final consolidated value (in the model fact table).
Data origin classification: Explicit tagging indicating whether the value originated from an automated Import job or a manual Writeback action.
User accountability: The specific user ID that committed or updated the value.
Execution timestamps: The date and time records for every import run and writeback transaction.
Dimensionality and mapping traceability: The source dimension members and the exact mapping rules applied.
Adjustment history: A historical audit log showing pre-adjustment (“old”) against post-adjustment (“new”) amounts for iterative writeback adjustments.
Architecture and technical mechanics
When Extended drillback is enabled for a consolidation model, the platform automatically creates and maintains a dedicated audit table:
Table Name: drillback_details_<model_name>
Database table growth
Because every import row and subsequent writeback event appends records to the drillback_details_<model_name> table, high-frequency writeback workflows or daily re-imports of multi-row staging tables can cause exponential table growth.
Warning: Unmonitored writeback activity or daily re-imports of large staging volumes can cause the drillback_details_<model_name> table to consume substantial database storage.
Enable Extended drillback primarily on production consolidation models during formal reporting periods.
Import reset implications
Running a subsequent data import on previously adjusted intersections overrides the previous audit chain in the active drillback view.
Finalize automated data loads before starting manual writebacks, journal entries, or top-level adjustments during the close window.
Configuration requirements
To use Extended drillback fully, you must set up three interconnected parts across the model, workflow, and Anaplan XL reports.
Enable model-level drillback
Open Anaplan Financial Consolidation and Reporting.
Go to Models.
Select your consolidation model and select the ellipsis .
Select the Extended drillback checkbox.
Select Process. The system initializes the backend logging schema.
Configure the File Import task
In your Anaplan Financial Consolidation and Reporting workflow process, select the Task Toolbox tab, drag and drop the File Import task to the workflow, and connect it to Start.
Select the task and Edit.
Edit the File Import (for example, GL_Trial_Balance_Load).
Select the Track Data Import checkbox.
Select Save and Start to run the workflow task.
Configure reporting workbook drillthrough
Open your Anaplan XL Reporting workbook.
In the Anaplan XL ribbon, select Options > Workbook Options > Connections.
Select Drillback from the dropdown for the Anaplan FCR options Drillthrough type.
Select OK.
Note: Make sure all template workbooks have the Drillthrough type set to Drillback. This will prevent the default revert to Standard, which is the dimension drilldown.