OLAP operations

OLAP operations

1. Roll-up

   • Performs Aggression on a data cube in two ways
     • Climbing up a concept hierarchy for a dimension
     • Dimension Reduction

2. Drill-down

   • Reverse of Roll-up, navigates from less detailed data to more detailed data
     • Stepping down a concept hierarchy for a dimension
     • Introducing additional dimensions

3. Slice

   • Performs a selection on one dimension
     • Results in a sub cube

4. Pivot

   • Visualization operation that rotates the data axes in view
     • Provides an alternative presentation of data

5. Dice

   • Performs a selection on two or more dimensions