Choose Index below for a list of all words and phrases defined in this glossary.

Drill Up

index | Index

Drill Up - definitions

Drill Up - Also known as rolling up data, drilling upward summarizes data, such as aggregating individual sales to a total sales.

[Category=Data Governance ]

Source: The Data Governance Institute, 01 December 2009 15:17:51, External

These advertisers support this free service

Drill Up - The ability to move between levels of the hierarchy when viewing data with an OLAP browser.  Drill Up - Changing the view of the data to a higher level of aggregation. 

Multidimensional Analysis (OLAP) tools organize the data in two primary ways: in multiple dimensions and in hierarchies.

Drilling down and drilling up allow an analyst to move down and up the hierarchies to see how the information at the various levels is related. After looking at the sales totals for a store's departments, the analyst may want to drill down to see the individual sales for each employee in one of the departments. Then the analyst may choose to drill up to view how this store's total sales compare to other stores in the same region.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 07 May 2010 07:55:48, SDG Computing, now offline

Drill Up - Data analysis to a parent attribute.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 30 November 2010 10:25:45, External

Drill Up (Roll up) - It is a specific analytical technique whereby the user navigates among levels of data ranging from the most detailed (down) to the most summarized (up) along a concept hierarchy. For example, when viewing the data for the city of Toronto, a roll-up operation in the Location dimension would display Ontario. A further roll-up on Ontario would display data for Canada.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 29 October 2012 12:05:02, External 


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: