Online Analytical Processing Pivoting:changing the dimensions used in a cross-tab is called Slicing:creating a cross-tab for fixed values only Sometimes called dicing,particularly when values for multiple dimensions are fixed. Rollup:moving from finer-granularity data to a coarser granularity Drill down:The opposite operation-that of moving from coarser- granularity data to finer-granularity data Database System Concepts-5th Edition,Aug 26,2005 18.9 ©Silberschat乜，Korth and SudarshanDatabase System Concepts - 5 18.9 ©Silberschatz, Korth and Sudarshan th Edition, Aug 26, 2005 Online Analytical Processing Pivoting: changing the dimensions used in a cross-tab is called Slicing: creating a cross-tab for fixed values only Sometimes called dicing, particularly when values for multiple dimensions are fixed. Rollup: moving from finer-granularity data to a coarser granularity Drill down: The opposite operation - that of moving from coarser￾granularity data to finer-granularity data