ITWissen.info - Tech know how online

drill down

Drill-down refers to a navigation technique in interactive OLAP evaluations, the "descending" to the next lower level of detail of a dimension. This allows data to be viewed at a more detailed level.

Online Analytical Processing (OLAP) is organized hierarchically. For example, the Delivery Address dimension at the top level may consist of the countries to which deliveries have been made. Below that is the level of regions, below that come the cities, then the postal codes, and then the actual addresses.

In an interactive evaluation as described in the ad-hoc evaluation, the figures can be viewed first per country, for example. The user analyzes a country by drilling down on it. He clicks on a certain country in the OLAP tool and gets the same evaluation with the regions of the clicked country and the aggregations offacts belonging to this level.

The opposite term to drill-down is drill-up. The term drill-down is also related to the term drill-through.

Informations:
Englisch: drill down
Updated at: 15.10.2013
#Words: 159
Links: navigation (NAV), online analytical processing (OLAP), level, data, indium (In)
Translations: DE
Sharing:    

All rights reserved DATACOM Buchverlag GmbH © 2024