Dimensional Data Operation - Drill through

Data System Architecture

About

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 indicate vertical movements between components, drill through is an action in which you move horizontally between two items via a related link.

In data warehousing, generally, Drill-through is the ability to navigate from data/reporting of a data source to data found in another data source.

This concept is used primarily in MOLAP cubes where detailed atomic data is not usually kept.

Example

master /detail relationship

The case of two reports that are in a master /detail relation with each other, and by clicking a master item on the master report you reach the details of the clicked item on the details report.





Discover More
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...



Share this page:
Follow us:
Task Runner