In this article:

Setting Up Links Between Data Source and Data Consumer Dimensions

Examples of Work of Link between Data Source Dimensions and Data Consumer Dimensions

Examples of Behavior

Examples of Offset

Selecting and Setting Up Data Sources

Data sources determine the objects, based on which a calculation block will be executed. The following repository objects can be used as data sources:

Data sources can be selected and set up on the Sources page in the calculation block editing wizard:

To select and set up a data source:

  1. Click the Add button.

After executing the operation the Sources dialog box opens:

  1. Select the object that will be used as a data source and click the Apply button.

To find object, start typing object's partial or full name in the search field. After executing the operation the side panel displays the objects, which names satisfy search conditions.

As a result, a data source is added. If required, similarly add other data sources.

  1. Select calendar role. By default, a calendar is considered as a calendar dimension and it cannot be used to set up links. To work with calendar as a standard dimension, select the calendar checkbox located next to the data source name. Calendar will be displayed in the list of source dimensions and it can be used as a standard dimension. To use calendar as a calendar dimension, deselect the Calendar checkbox.

  2. Set up links between data source and data consumer dimensions. The links set correspondence between data source dimensions and data consumer dimensions therefore reduce the number of calculated elements and speed up block calculation. To set up links, click the Set Up Links button. The Set Up Links dialog box opens to set links.

To automatically set up links by attribute identifiers in equal data consumer and data sources dimensions, click the ind All button.

As a result, the data source is added and set up. If required, similarly add other data sources.

To remove a data source:

  1. Select the data source.

  2. Click the Remove button.

NOTE. If the data source is used in calculation formulas, edit formula terms manually on removal:

After executing the operation the selected data source is removed.

Setting Up Links Between Data Source and Data Consumer Dimensions

The links set correspondence between data source dimensions and data consumer dimensions therefore reduce the number of calculated elements and speed up block calculation.

To set up links between data source and data consumer dimensions, use the Set Up Links dialog box. A link can be set up in simple and advanced modes. The dialog box appearance differs depending on the setup mode:

The Set Up Links dialog box opens in simple mode by default. To access advanced settings, toggle the Advanced Mode switch to active state.

The Source Cube Dimension column displays all source dimensions.

Setup order:

  1. Select the attribute to be linked in the data source dimensions in the Source Attribute column.

  2. Select the attribute in the data consumer dimension containing the same values as the selected source attribute in the Consumer Dimension and Attribute column. The list contains only consumer dimensions, for which filtering is set up.

For example, the Key attribute is selected in the Territories dimension. To create a correct link, in the data consumer select the attribute containing territory key in the dimension with corresponding data.

  1. Select the link work option in the Behavior column:

NOTE. The Behavior column is available only in the advanced setup mode.

  1. Select the selection offset type in data source dimension in the Offset Type column:

NOTE. The Offset Type column is available only in the advanced setup mode.

  1. Set the number of elements, by which data source dimension selection will be offset, in the Lag column.

NOTE. The Lag column is available only in the advanced setup mode.

As a result, the link by attributes between dimensions is set. If required, similarly add other attribute links.

To automatically add all possible links based on:

To delete the link between attributes, click the Delete button in the Delete column next to the corresponding line.

Examples of Work of Link between Data Source Dimensions and Data Consumer Dimensions

The example displays functioning of the link with different behavior and offset. The dimension in used are abstract and are used to show how links work. The dimensions selection is based on MDM dictionaries that are basis for these dimensions.

Examples of Behavior

For example, there is the Indicators dimension in the data consumer and the Countries dimension in the data source. The dimensions contain the following data and the following selection:

A link is set up between the Key attribute in the Countries dimension and the Country Code attribute in the Indicators dimension:

Consider the selection that will be used in the calculation block on different link behavior:

Selection obtained on behavior of a default link:

Selection obtained on data consumer filtering:

Selection obtained on replacing the not found element with empty values:

Examples of Offset

For example, there is the Indicators dimension in the data consumer and the Countries dimension in the data source. The dimensions contain the following data and the following selection:

A link is set up between the Key attribute in the Countries dimension and the Country Code attribute in the Indicators dimension:

Consider the selection that will be used in calculation block if the link uses the offset with different values:

The selection obtained on applying the offset by one element forward:

Selection obtained on applying the offset from the first element by one element forward:

The selection obtained on applying the offset from the last element by one element backward:

See also:

Inserting and Setting Up Calculation Blocks