Creating a standard slice

  1. Open the report in which to create the slice. In Design mode right-click the Slices folder in the Accessories pane and select New Slice.
  2. Specify a name for the slice and, optionally, a description.
  3. Select Standard as the type of slice.
  4. Select the data connection and cube on which to create the slice.
  5. To make the slice expandable select True in the Expand and collapse field in the Source section.
    By default, True is selected and you can control the slice hyperblocks expansion and collapse. To control how each axis hierarchy expands and collapses, use the Format Hyperblock dialog box settings. Select False to make slice hyperblocks not expandable.
  6. Click Add Hierarchy in the Rows section and select the hierarchy to form the rows of the report. Select the type of suppression to apply to the rows.
    By default, None is selected and no values are excluded from the results. Select Empty or Zero & Empty to exclude rows that contain only empty values or only zero values.
  7. Optionally, click Edit list in the 1st Segment column and use the list designer to specify which elements to include on the horizontal axis of the slice.
    If you do not edit the list, all elements of the hierarchy are included.
  8. Optionally, click Add Segment to add further segments of the hierarchy to the horizontal axis.
  9. Add further hierarchies and segments to the horizontal axis as required.
    You can add up to fifteen segments of each hierarchy.
  10. Repeat steps 6 to 9 to specify the hierarchies and segments of the vertical axis in the Columns section.
  11. To filter and sort the elements displayed by a segment, click Edit Axis and specify filter and sorting criteria.
  12. To add filter, or slice, hierarchies, click Add Hierarchy in the Data Area. Then click Edit slice in the Selection column to select the elements of the filter in the slice designer. Select an aggregation function from the Aggregation list. By default, the sum of the values is returned.
    If your report already includes lists, in combo boxes for example, you can click Fill to automatically add those lists as filters.

    You can add multiple filters, but only one selection of elements for each.

    The Preview pane updates to show the results of your changes.

  13. Click OK.

The XML definition of a slice is displayed in the XML Definition field of the Properties pane.

Related topics