Combination of dimensions is available in express reports, dashboards.
Combination of dimensions merges several dimensions into one and displays its elements as a time series tree similarly to workbook. Combination of dimensions decreases source dimensionality. Name of combined dimension elements consists of names of elements of source dimensions separated with a dash.
The following components can be used as a data source, from which dimensions may be used to form a combined dimension:
Standard cube.
Virtual cube.
Time series database.
Calendar dictionaries cannot be used in a combined dimension.
Each express report sheet or each dashboard block can contain only one combined dimension.
When combined dimensions are used, data validation is unavailable. When creating a combined dimension a previously configured validation will be disabled.
When creating a combined dimension calculated elements contained in dimensions will be deleted.
When creating a combined dimension, the Map visualizer will be disabled if the combined dimension includes the observation objects dimension or a dimension containing territory binding attributes.
To create a combined dimension, click the
Combine button on the Hierarchy ribbon tab and select in the drop-down menu:
Data source dimensions required for combination.
The Time Series Mode item for combination of all available data source dimensions.
NOTE. The Hierarchy tab is available if the Selection group of tabs is opened on the side panel.
As a result, the selected dimensions are combined into one. When creating a combined dimension, selection is formed from selection of source dimensions.
Tabs on the Selection group of tabs of the side panel are used to work with a combined dimension:
The tab with a list of elements.
The Data tab containing a series tree.
Name of the tab with a list of elements is formed from names of source dimensions separated with a vertical line. For example: Territories | Indicators, where Territories and Indicators are names of source dimensions.
To undo combination of dimensions, select a tab with the list of combined dimension elements in the Selection group of tabs on the side panel and execute one of the operations:
Select the Alternative Hierarchy > Reset item in the dimension's context menu.
Click the Alternative Hierarchy > Reset item on the Hierarchy ribbon tab.
Deselect all dimensions in the drop-down menu of the
Combine button on the Hierarchy ribbon tab.
The Data tab presents elements of a combined dimension as a time series tree:

Time series can be added to a visualizer selection as follows:
Double-click a series or folder with series.
Drag the required series to the workspace.
Tree structure and name of a series are formed based on a calculation chain in the upper part of the panel.
When creating a combined dimension the calculation chain is formed from the current selection of dimensions in use.
Calculation chain and series tree can be set up using the buttons next to dimensions names:
Move Down/Up. Dimensions hierarchy setup in a series tree.
Settings Menu. Deleting of dimension from the chain or setting up filtering and sorting.
Elements List. Selection of elements, which are used into create tree structure. Standard commands for working with dimensions selection are available in the context menu.
The list of combined dimension elements contains time series formed by the calculation chain on the Data tab:

To work with elements of combined dimension, see the Working with Dimension Elements section.
NOTE. The following is unavailable when working with combine dimensions: use of selection groups, alternative hierarchy, selections schemas, adding a new calculated element, aggregating element, subtotal/total.
See also: