OLAP Operations

OLAP Operations

1. Drill-down

   • Reverse of roll-up
     • Actual Dimensions
     • Stepping down Hierarchy Dimension

2. Pivot (Rotate)

   • Visualization by rotation
     • Presentation

3. Roll-up

   • Aggression
     • Dimension Reduction
     • Climb-up Hierarchy Dimension

4. Slice and dice

   • One dimension
   • Multi-dimensional
     • Sub-cube