Define the concepts of rollup and drilldown and indicate how they acre useful in operations reporting.
Answered Essay: Define the concepts of rollup and drilldown and indicate how they acre useful in operations reporting.
Expert Answer
There are two operations we use when displaying data at multiple levels and they are drill-down and roll-up.
Drill-down operation can be described as process of displaying and viewing of data at level of increasing detail. Roll-up operation can be described as process of displaying and viewing of data at level of decreasing detail. Selective roll-up and drill-down are permitted by the system of non-brushed and brushed regions independently.
Roll-up are useful in operations reporting in following way:
- It performs aggregation by climbing upon concept hierarchy on a data cube.
- It helps in dimension reduction.
Drill-down are useful in operations reporting in following way:
- It helps in navigating starts from less detailed data to more detailed data by introducing some additional dimensions.
