a) Course, b) Student, c) Time & a measure d) Aggregate marks.

Create a Cube and describe following OLAP operations:

i) Rollup ii) Drill down iii) Slice iv) Dice v ) Pivot.

Fact : marks - obtained

Dimensions : course, student & time.

Let the current level of gram is each cell gives aggregate marks of each student for a individual cluster of courses for each semester.

"X" is the total aggregate marks obtained by student S1 in semester 1 for all …