Slice and Dice multidimensional analysis technique allows users to rearrange dimensions in a report and provide broad perspectives of the data.

Slicing and Dicing in Cognos can be performed in the following ways:

  • Dragging and dropping the dimension folders from a dimension viewer (on the left) or dimension toolbar (in the top) to the crosstab area
  • Selecting category in a dimension viewer and doing the right click on the selected category and choosing Replace Rows (or Replace Columns or Replace Layers)
  • Selecting category in a dimension viewer and clicking the corresponding icon from the left-hand side menu
  • Swapping rows and columns is also a Slice and Dice cube investigation activity. It can be accessed from Main Menu -> Explore -> Swap -> Rows and Columns

DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.