Combining Dimensions

Combination of dimensions merges several dimensions into one and displays its elements as a time series tree.

Combined dimension displays elements as a time series tree similar to the Time Series Analysis tool and reduces data source size. Name of combined dimension elements consists of names of elements of source dimensions separated with a dash.

NOTE. Combination of dimensions is available in the Dashboards and the Analytical Queries (OLAP) tools.

Features of Combined Dimensions Work

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

Calendar and scenario dictionaries cannot be used in a combined dimension.

Each sheet of express report or each dashboard block can contain only one combined dimension.

When combined dimensions are used, data validation is not available. On creating a combined dimension a previously configured validation will be disabled.

On creating a combined dimension calculated elements contained in dimensions will be deleted.

On creating a combined dimension, the Map visualizer will be deactivated if 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 tab is selected on the side panel.

As a result, the selected dimensions are combined into one. On creating a combined dimension, selection is formed from selection of source dimensions.

Tabs on the Selection group of tabs of the side panel are available 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 following 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.

On 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. One cannot use selection groups, alternative hierarchy, selection schemas in a combined dimension and add a new calculated element, aggregated element, the Subtotal and the Total element.

See also:

Setting Up Dimensions and Element Selection