AX2669

Drill-Through definitions

If you want users to be able to "drill through" the data in one table to the detailed sub-GL data in another table, then you must set up drill-through definitions.

A drill-through definition does the following:

• Specifies the target table that holds the detailed data
• Specifies the number of drilling periods (columns) for the definition
• Defines the filters to determine the appropriate data to return when drilling a specific period
• Maps the drilling periods to one or more column sequences in data tables

For example, if a report is displaying actuals data from the GL2020 table, you want users to be able to "drill through" to the transactions data held in the GLDetail table. To do this, you need to set up a drill-through definition for the GLDetail table that maps the data in that table to the appropriate columns in the GL2020 table.

This section discusses how to manage drill-through definitions for a system. For more information on how users use the definitions to drill data, see Drilling data: Using Drill Through. For more information on how drill-through drilling works and file design considerations, see Setup for Drill Through.