Slices

Many reports contain a hierarchy on the row axis and a hierarchy on the column axis. The elements of the hierarchies form the column and row headings of the report. Further hierarchies are used as filter hierarchies. The elements that users select from the column, row, and filter hierarchies affect the values that they see. For example, they might view the value of sales of all products in Europe in 2019, or the revenue from a particular sales channel for a single product in 2020.

You can put multiple elements from multiple hierarchies on an axis. For example, you might display a product hierarchy and period hierarchy on the column axis. In this case the report displays a value for every combination of product and period. You can also put multiple groups of elements from a single hierarchy on an axis. For example display the quarters of the previous, current, and future years, to compare actual, budget, and forecast values. Each such group of elements is a segment.

There are two ways in which to design such a report layout. The first is to use lists in hyperblocks and other report objects. The second is to define slices in which the row, column, and filter dimensions are defined in a single object. With slices, if suppression of zero or empty values is required, calculation of the report values is quicker and more efficient than with lists. If you use lists, calculation of the lists, calculation of the values, and zero suppression requires separate calls to the database.

When you create a slice, the data that it references is read from the database and held in memory. Typically, you use a SLICEGET formula to read the data and display it.

You create slices in the New Slice dialog.

If you already have a suitable XML variable, you can select Variable Slice in the New Slice dialog and select the variable.

To create an XML variable for use as a slice requires the use of several slice functions.

Any MDX statement that returns a table as the result set can be used to define a slice. Select Custom MDX in the New Slice dialog. Variables and functions can be incorporated in the MDX.