Slices

A slice is a subsection of data within the cube, defined by a set of dimension elements.

In order to implement a self service ready cube, there must be as many slices as there are dimension combinations possible. Therefore, when the end user builds their views, the most efficient slice will be used.

Important

You must create a Master Slice that contains all the dimensions of the cube.

The slice with the most dimensions will automatically be marked as Master by the OLAP Manager.

Tip

Increase performance by balancing the amount of records in slices. For example, if regular slices have around 1000 records and one slice has 500000, it means there is a big difference of dimensions between the slices and therefore some slices are missing.

To access the list of slices of a cube:

  1. In the Cubes list, click one cube.
  2. Untick the In Production checkbox and click Save.
  3. In the Navigation Bar, click Navigation and select Slices.
Column Description
Slice Name of the slice.
Master Only one slice is Master, and it contains all dimensions.
Records Number of records in the slice.
Dimensions Number of dimensions per slice.
Parent Slices that contains all the dimensions of the slice. The master slice does not have a parent.