OLAP Operations

#OLAP

Roll-up or Drill-up

The word ‘up’ in the names refers to going up in concept hierarchies.

For example, we would like to know the revenue of the whole year. However, the record of data is

DateRevenue
2018-01-011023
2018-01-02934
2018-12-301244
2018-12-311302

Roll-up is performed by summing up everything of the column revenue. It gives us the revenue of the whole year. Monthly and quarterly roll-up is also straightforward.

Published: by ;

Current Ref:

  • wiki/data-warehouse/olap-operations.md