Using the drill-through query
Start using drill-through queries
Excel > CCH® Tagetik > 
Navigation > select form >
- Click
: the Drill-through tab containing a list of drill-through queries defined in the form will open in the left-hand panel. - Select the desired cell.
- Do the following;
| If you want to run... | Then... |
|---|---|
| a specific query | 1. From the list, select the query to be run. 2. Click: the system will run the query according to the filters of the selected cell. |
| all available queries | click : the system will run the query according to the filters of the selected cell. |
Enable the automatic running of drill-through queries
Excel > CCH® Tagetik > Navigation > select form >
- Click : the Drill-through tab containing a list of drill-through queries defined in the form will open in the left-hand panel.
- Live mode: the system will automatically run drill-through queries every time a cell is selected.