To work with the tool in Foresight Analytics Platform 10, use the new interface.

Merging Dimensions and Tucking Dimension Elements

If several dimensions are displayed in the sidehead, use merge and tuck settings for a more compact table area sidehead layout. Settings are determined on creating or editing a table area on the Sidehead Structure page of the Set Up Table Area dialog box.

Merge

Available merging options:

NOTE. To merge dimensions of table and calculated dictionaries, one should add levels.

After executing the operations, the icon is displayed next to merged dimensions in the Set Up Table Area dialog box.

Tuck

To merge elements of one dimensions with elements of another dimension, tuck dimensions. When tucking is used, the dimension element to be tucked will be no more displayed in a separate string, its values will be displayed in the dimension element string, to which tucking is executed. When tucking area type and formatting of tucked dimension element will be changed to area type and formatting of the dimension element, to which tucking is executed.

NOTE. Only merged dimensions can be tucked.

To tuck elements:

  1. Select the Tuck Elements checkbox in the dimension's context menu.

  2. Select the Set Up item or select the selection schema in the Selection Schema drop-down list to determine dimension elements selection in the dimension's context menu. The item and selection schema are available after the Tuck Elements checkbox is selected.

  3. After executing the Set Up item, the dialog box opens. Select dimension elements to be tucked in the dialog box:

For each dimension element, to which tucking is set up, it is checked if there are tucked elements of the underlying dimension:

NOTE. Selecting several elements is required when filtering of shared dimensions or filtering by indicator results in the various elements of tucked dimension under each element of the upper dimension.

  1. Save changes by clicking the Save button.

NOTE. If in the sidehead, untucked dimensions are located to the right from the tucked ones, then it will be tucked when untucked dimensions display one element. Such a behavior stays unchanged on transposing.

After executing the operations, the icon is displayed next to tucked dimension in the Set Up Table Area dialog box.

If additional element names of dimension are displayed in the sidehead, only the first displayed names are merged. Additional dimension names are not merged.

If tucking was set up for the dimension, and then the dimension was moved to the first place, on moving the dimension back, the tuck setting is saved.

Example of merge and tuck use

See also:

Getting Started with the Interactive Data Entry Forms Extension in the Web Application | Setting Up Sidehead Structure