Multidimensional data sources can be divided into data slices that are used to create visualizers on a report sheet. The side panel is used to work with data slices. The default slice name: Slice N, where N - number of the slice created within one regular report.
The following elements can be used as data sources:
All cube types, including child cubes of modeling container.
Available operations:
To add a new slice, execute one of the operations:
Using the Drag&Drop method:
Hover the cursor over the required source. The cursor turns to .
Drag the source the required area. The top left border of the selected cell will be the left top border of a table or a chart built based on the created slice.
In the selection menu specify Table or
Chart> <Chart type>. A slice will be automatically added for the data source, and the selected visualizer will be added to the report sheet.
Using context menu:
Select an empty cell on a report sheet. The top left border of the selected cell will be the left top border of a table or a chart built based on the created slice.
Execute one of the operations:
Select the Add > Slice item in the data source's context menu on the Source panel.
Select the Add > Table or Add > Chart > <Chart type> item in the data source's context menu on the Sources panel. A slice will be automatically added for the data source, and the selected visualizer will be added to the report sheet.
On the Insert toolbar tab for the chart:
Select an empty cell on a report sheet. The top left border of the selected cell will be the left top border of a chart.
Select the chart type on Insert toolbar tab.
After executing the operations a data slice will be created. The new slice will be named Slice N by default, where N - slice number.
The slice is required for creating visualizers.
NOTE. On can add only one data slice for data sources including two or more cubes.
A data slice allows for creating the following visualizers:
To create a visualizer, execute one of the operations:
Using the Drag&Drop method:
Hover the cursor over the required source/slice. The cursor turns to .
Move the slice to the working area. The top left border of the selected cell will be the left top border of a table or a chart built based on the created slice.
In the selection menu specify Table or
Chart> <Chart type>.
Using context menu:
Select an empty cell on a report sheet. The top left border of the selected cell will be the left top border of a table or a chart built based on the required data slice.
Execute one of the operations:
To create a table, select the Add > Table item in the data slice's context menu on the Sources panel.
To create a chart, select the Add > Chart > <Chart type> item in the data slice's context menu on the Sources panel.
After executing the operations a table or a chart will be added to a report sheet.
The new table will be named Table N by default, where N - table number.
The new chart will be named ChartN by default, where N - chart number.
To delete data slice, select the Delete item in the selected slice's context menu. After executing the command the operation confirmation dialog box opens. Clicking the Yes button deletes the selected slice.
Deleting data sources and data slices also deletes all child objects. All tables and charts based on the slice are deleted for the slice.
To rename data slice, select the Rename item in the selected slice's context menu. After executing the command enter a new name and press the ENTER key.
To calculate and control data from data slice, use ready algorithms and determine their settings.
Set up display version in the list
The Sources panel contains the following object display options (data sources, slices and visualizers):
Show names. It is used by default.
Show addresses and identifiers.
To show addresses and identifiers, select the Show Addresses and Identifiers item in the context menu of any data source on the Sources panel. After executing the command, it will be marked with a checkbox.
NOTE. After the command is executed, addresses and identifiers of all data sources and their slices with visualizers are shown regardless of the data source, for which the command was executed.
To show object names again, execute the command again and deselect its checkbox.
See also: