Typical OLAP Operations
Roll up (drill-up): summarize data
- by climbing up hierarchy or by dimension reduction
Drill down (roll down): reverse of roll-up
- from higher level summary to lower level summary or detailed data, or introducing new dimensions
Pivot (rotate):
- reorient the cube, visualization, 3D to series of 2D planes.
Other operations
- drill across: involving (across) more than one fact table
- drill through: through the bottom level of the cube to its back-end relational tables (using SQL)