# Dimensional Data Operation - Drill Down / Up

Drilling down or up is a data navigation term along hierarchy levels of data ranging:

• from the most summarized (up)
• to the most detailed (down)

Drilling down is nothing more than adding columns from the dimension tables. Drilling up is removing them.

We can drill down or up:

• on attributes from more than one explicit hierarchy
• and with attributes that are part of no hierarchy.

## Example

• Within the time dimension, months roll up to quarters, quarters roll up to years, and years roll up to all years.
• Within the product dimension, products roll up to subcategories, subcategories roll up to categories, and categories roll up to all products.
• Within the customer dimension, customers roll up to city. Then cities roll up to state. Then states roll up to country. Then countries roll up to sub-region. Finally, subregions roll up to region.

Discover More
Dimensional Data Modeling - Hierarchy

in dimensional data modeling A hierarchy is a set of levels having many-to-one relationships between each other, and the set of levels collectively makes up a dimension in the form of a tree (A tree...
Dimensional Data Operation - Drill through

Drill through is a dimensional data operation that describe the act of exploring or browsing items like folders, files or related components. Generally associated with drill down and drill up, which...
Dimensional Data Operations (OLAP Operation)

This sections is all cube operations. The analyst can navigate through the database and screen for a particular subset of the data, changing the data's orientations and defining analytical calculationsSlicDicDrill...
Logical Data Modeling - (Atomic|Indivisible)

Atomic means indivisible. Atomic data is the most detailed information collected. Such data cannot be subdivided further and is said to be an the lowest grain. In data analysis, this is in general data...
OBIEE 10G/11G - Drilling (Down and Through)

Drilling is the action to discover the data along an hierarchy (ie through the different levels). In OBIEE, drilling is one way to navigate or interact within the data. OBIEE allows two types of drilling:...