Drill-through queries

Background

Data originating from external sources can be loaded to CCH Tagetik using ETL (see Extraction, Transformation & Loading). The ETL saves the data in a staging table before importing them into CCH Tagetik. This staging table may contain information on the data at a level of detail that is not present once the data has been loaded to CCH Tagetik.

Function utility

The drill-through query allows you to retrieve the data that makes up an amount that has been imported into CCH Tagetik from the staging table managed via ETL.

Example

An amount of € 978 is present on the Insurance account in CCH Tagetik. This amount has been imported from an ERP system containing the details that make up the amount in question. Setting the drill-through query therefore allows you to retrieve the following data:

Tagetik	ERP System
Insurance = € 978	- Insurance - Auto = 100 - Insurance - Accident = € 159 - Insurance - Fire = € 230 - Insurance - Goods = € 100 - Insurance - Other = € 398 Total insurance = € 978