Drill Down tab

Excel > CCH® Tagetik > Navigation > open form > Drill Down > Cell/Column/Row

Purpose of the tab

This window allows the user to view the components that make up an aggregated figure.

Tab elements

Element	Description
Drill down selection menu	Allows you to select the way in the which drill down is run on the data. - Details: only on cell. Shows details of the adjustments. - Lowest level elements: Dimensions: only on cell. Shows the highest level of detail on all dimensions involved. - Standard drill down: allows you to select the aggregation structures used to aggregate the data and dimensions to be used to view the composition of that data. - Lowest level: rows: only on cell. Shows the highest level of detail on all dimensions involved, distributing the values by user/insertion date.(not supported in AIH) - Headers: only on cell. Shows the journal headers.(not supported in AIH)
Dimensions management pane	Allows you to manage the selection of dimensions on which to run the drill down. The aggregation structures and dimensions currently used in the selected cell are shown in yellow.
Filters applied to the cell	Shows the properties of the selected starting cell. See Cell properties panel.

Actions on dimensions

The actions that can be run from the dimensions management pane are described below:

Element	Description
	Runs the drill down on child elements.
	Runs the drill down on lowest level elements.
OR	In the presence of OR row/column filters, shows details of the contributions of the value corresponding to that filter. For example, for a value deriving from the Sales revenues and Other revenues accounts defined as a OR row filter, the values of each of the two individual accounts can be seen.
	Only available on cells related to FST items that can be related or formula-type FST items. Shows the individual accounts that make up the FST item.
	Removes the selected dimension.
/	Moves the selected dimension up/down.