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

Create a Master Slice containing 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.

Example

If regular Slices have around 1000 records and there is one at 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 on one Cube.
  2. Untick the In Production checkbox and click on Save.
  3. In the Navigation Bar, click on Navigation and select Slices.

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 Dimensionsper Slice.
Parent:
Slices that contains all the Dimensionsof the Slice. The Master Slice does not have parent.