Adding a slice to a report

When you create a standard slice or a variable slice, the slice is displayed in the Slices folder of the Accessories pane. Expand the slice to see the Rows and Columns parts of the slice. To see which elements are included, right-click Row or Columns and select Preview.

When you drag a slice to a report, overlapping hyperblocks are created. The row axis forms the vertical hyperblock and the column axis forms the horizontal hyperblock. The two hyperblocks share the same value cell. The value cell contains a SLICEGET formula that returns the value of the slice.

If you expand the slice in the Accessories pane, you can drag the row and column axes to the report separately. Each forms a separate hyperblock.

Insert a function in the value cell to return data.

Unlike hyperblocks that are created from lists, the concept of global and local lists does not apply to slices. This table shows the differences between hyperblocks created from lists and hyperblocks created by slices:
Hyperblock created from list Hyperblock created by slice
When you drag a list into a report to create a hyperblock, the list is copied into a local list. If you then edit the global list, your changes have no effect in the report, unless you delete the existing hyperblocks and then drag the new version of the list into the report. If you edit the rows or columns of a slice, your changes have effect immediately in the report.
If you click a hyperblock that has been created from a list, the list designer is enabled and you can edit the local list. To edit a slice, you must right-click the slice in the Accessories pane and select Edit.