Drilldown and Drillup: Information Panel

To get detailed or general information about data, use data drilldown or drillup.

The operations are available for the dimensions selected during drilldown setup.

Drilldown

NOTE. Drilldown is unavailable if cells from different data sources and/or elements of different dimensions are included in the selected data area range.

Data drilldown is available only for the dimension elements, which have child elements. Drilldown moves to a lower level of dictionary hierarchy.

To drill down data by hierarchy:

Select:

One or several table sidehead or heading elements.
One or several table data cells.

Select the Drill Down context menu item.

After executing the operations all selected data is drilled down:

For dimension elements if they have child elements.
For data cells if intersecting dimension elements in these cells have child elements.

Behavior of selection during drilldown depends on the state of the Extend Selection switch:

If the switch is inactive, the selection is rebuilt: all child elements of the lower dimension level are selected.
If the switch is active, the selection is extended: all child elements of the lower dictionary level are added to the existing selection.

If there is no hierarchy or the selection is on the lower hierarchy level, dimension elements can be drilled down with replacement of the dimension with the dimension in filter.

Dimension elements and data cells can be drilled down with replacement of the dimension with available dimensions in filter:

If the selected sidehead/heading dimension does not have hierarchy or the lowest hierarchy level is reached, the following happens when the Drill Down item is selected:

Dimension in filter, depending on the set order, will be moved to sidehead/heading.
Selection of the replacement dimension will be saved or will become full if it was not set before.
Dimension from sidehead/heading with saved selection will be moved to filter, depending on the position of the replacement dimension before drilldown.

If sidehead/heading dimensions do not have hierarchy or the lowest hierarchy level is reached for the selected cell or cell range, the following happens when the Drill Down item is selected:

Dimension in filter, depending on the set order, will be moved to sidehead.
Selection of the replacement dimension will be saved or will become full if it was not set before.
The rightmost sidehead dimension with saved selection will be moved to filter, depending on the position of the replacement dimension before drilldown.

Drilldown into relational data is available:

For data cells obtained using fact dimension aggregation.
If sidehead dimension does not have hierarchy or the lowest hierarchy level is reached.
Dimensions that are available for drilldown are higher in the order than sidehead dimension.

After the Drill Down command is executed, the records are displayed from the fact table, by which the cell value is formed as a flat table. The Dimensions area on the Sources panel displays the Source Fields additional dimension located in columns and containing all fact table fields, including the fields that are linked to cube dimensions, and the Row Numbers dimension located in rows.

Drillup

NOTE. Drillup is unavailable if the selected data area range contains cells of different data sources and/or elements of different dimensions.

Data drillup is available only for the dimension elements, which have parent elements. Drillup moves to a higher level of dictionary hierarchy.

To drill up data by dimension elements:

Select:

One or several table sidehead or heading elements.
One or several table data cells.

Select the Drill Up context menu item.

After executing the operations all selected data is drilled up:

For dimension elements if they have parent elements.
For data cells if intersecting dimension elements in these cells have parent elements.

Behavior of selection during drilldown depends on the state of the Extend Selection switch:

If the switch is inactive, the selection is rebuilt: all elements of dimension's parent level are selected.
If the switch is active, the selection is extended: all elements of dimension's parent level are added to the existing selection.

If there is no hierarchy or the selection is on the higher hierarchy level, dimension elements can be drilled up with replacement of the dimension with the dimension in filter.

Dimension elements and data cells can be drilled up with replacement of the dimension with available dimensions in filter:

If the selected sidehead/heading dimension does not have hierarchy or the highest hierarchy level is reached, the following happens when the Drill Up item is selected:

Dimension in filter, depending on the set order, will be moved to sidehead/heading.
Selection of the replacement dimension will be saved or will become full if it was not set before.
Dimension from sidehead/heading with saved selection will be moved to filter, depending on the position of the replacement dimension before drillup.

If sidehead/heading dimensions for the selected cell or cell range do not have hierarchy or the highest hierarchy level is reached, the following happens when the Drill Up item is selected:

Dimension in filter, depending on the set order, will be moved to sidehead.
Selection of the replacement dimension will be saved or will become full if it was not set before.
The rightmost sidehead dimension with saved selection will be moved to filter, depending on the position of the replacement dimension before drillup.

Dimension Replacement

These dimensions can be replaced if drilldown is available for sidehead/heading dimension.

Replacement is also executed when the Drill Down/Drill Up item is selected upon reaching the lowest/highest level of dimension hierarchy or if there is no hierarchy in the dimension.

Moving to Level

Undoing the Last Step

To return to the previous step during drilldown, drillup, replacement, and moving to level, select the cell, cell range, one or several dimension elements and select the Back context menu item.

Restoring to Original State