Dimensional Data Operation - Drill Down / Up

Data System Architecture


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.


  • 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
Star Schema
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...
Data System Architecture
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...
Data System Architecture
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...
Data System Architecture
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 Dimension Drill Down Report
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:...

Share this page:
Follow us:
Task Runner