i) Course, ii) Student, iii) Time & measure Aggregate marks Create a Cube and describe following OLAP operations.
i)Slice ii) Dice iii) Roll up iv) Drill down v) Pivot

Dimensions : course, student, time fact : Aggregate marks.

• Each cell gives aggregate marks for each student, for each course year wise.

1. Slice : It is used to obtain a particular slice of the cube.

example : Aggregate marks of all students for all courses in the year 2016.

2. Dice : It is used to obtain a small portion of the cube covering all the dimensions.

example : Aggregate marks of all BE students, for courses of DB cluster for test five years.

3. Roll up : It is used to obtain generalized level of data from the current level example : Cluster wise aggregate marks for all students for every year.

4. Drill down : It is used to obtain detailed level of data from the current level.

example theory, T/w & viva marks for all students for every year.

5. Pivot : It is used to analyze the some data from different perspective

example : Analyzing aggregate marks course arise.