In this article:

Features of Combined Dimensions Work

Creating a Combined Dimension

Combined Dimension Series Tree

Forming of Tree Structure

List of Combined Dimension Elements

Combining Dimensions

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.

Features of Combined Dimensions Work

The following components can be used as a data source, from which dimensions may be used to form a combined dimension:

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.

Creating a Combined Dimension

To create a combined dimension, click the Combine button on the Hierarchy ribbon tab and select in the drop-down menu:

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:

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:

Combined Dimension Series Tree

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:

Forming of Tree Structure

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:

List of Combined Dimension Elements

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:

Working with Dimensions | Using Private Dimensions