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.
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.
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:
- In the Cubes list, click one cube.
- Untick the In Production checkbox and click Save.
- 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. |