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.
Operations available for data sources, slices and data visualizers:
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.
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.
A data slice allows for creating the following visualizers:
Table.
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 .
Drag the source/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.
NOTE. When the source is dragged to the working area, a new slice is added automatically.
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 source's context menu on the Source panel. A new data slice will be created for the data source, based on which a table will be created on a report sheet.
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 source's context menu on the Sources panel. A new data slice will be created for the data source, based on which a chart will be created on a report sheet.
Select the Add > Chart > <Chart type> item in the data slice's context menu on the Sources panel.
Select the Add Chart > <Chart type> item in the table's context menu on the Sources panel.
NOTE. When a chart is added in the table's context menu, it will be created above the selected table.
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.
Delete data source, slice and visualizer
To delete data source, data slice or data visualizer, select the Delete item in the context menu of the selected data source, slice or visualizer. After executing the command the operation confirmation dialog box opens. Clicking the Yes button deletes the selected data source, slice or visualizer.
Deleting data sources and data slices also deletes all child objects. For example, all slices are deleted for a data source, as well as all tables and charts based on these data slices.
Rename data source, slice or visualizer
To rename data source, data slice or visualizer, select the Rename item in the context menu of the selected data source, slice or visualizer. After executing the command enter a new name and press the ENTER key.
To calculate and control data from data slice, use the created calculation 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 items in the context menu of any data source on the Source 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.
To aggregate fixed dimensions in a table:
Select the required table:
Click the table name on the Sources side panel tab.
Put the cursor to the cell with table data on the report sheet.
Click the Parameters button on the toolbar. Make sure that the Table element is selected in the drop-down list on the parameters panel.
Go to the Data tab on the parameters panel.
Select the required aggregation method in the Aggregate Fixed Dimensions drop-down list:
No. Data is not aggregated.
Sum. The selected elements in fixed dimensions are summed.
Average. The mean of selected elements in fixed dimensions is displayed.
Maximum. The maximum value is displayed from the selected elements in fixed dimensions.
Minimum. The minimum value is displayed from the selected elements in fixed dimensions.
From Source Dimensions. Fixed dimensions use aggregation according to the set aggregation methods of source dimensions.
From Source Facts. Fixed dimensions use aggregation according to the set methods of source facts aggregation.
After executing the operations, data aggregation will be set up for the table.
See also: