Creating a standard slice

  1. Open the report in which to create the slice. In the 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.
    The True option is selected by default 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. To view the inverted hierarchy, select True in the Invert Hierarchy field in the Advanced list settings section.
    This option is available if the Expand and collapse field is set to True. You must add only one inverted hierarchy on one of the axis. The other axis can have multiple, not inverted, hierarchies.
  7. 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.
    The None option is selected by default and no values are excluded from the results. Select Empty or Zero & Empty to exclude rows that contain only empty values or only zero and empty values.
  8. Optionally, click Edit list in the first 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.
  9. Optionally, click Add Segment to add further segments of the hierarchy to the horizontal axis.
  10. Add further hierarchies and segments to the horizontal axis as required.
    You can add maximum 15 segments of each hierarchy.
  11. Repeat steps 7 to 10 to specify the hierarchies and segments of the vertical axis in the Columns section.
  12. To filter and sort the elements that are displayed by a segment, click Edit Axis and specify the filter and sorting criteria.
  13. To add a filter, slice, or hierarchy, 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 field.

    The Preview pane is updated to show the results of your changes.

  14. Click OK.

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

Related topics