In this article:

Setting Up Sidehead Structure

Sidehead structure includes dimension elements displayed in the table area sidehead and their display order.

To set up sidehead structure, use the Sidehead Structure page of the Table Area Wizard dialog box:

Sidehead structure

NOTE. If transposing was applied, the page will be named Heading Structure, in the advanced settings area, the checkboxes will be named Column Headers and Column Numbering, the Multilevel Table Heading checkbox will be added, the other settings remain unchanged.

To determine sidehead structure:

Set up elements in sidehead dimensions.

To determine additional settings of sidehead structure:

Change position order of dimensions in the sidehead.
Merge dimensions and tuck its elements for more compact sidehead display.
Group elements to merge dimensions by specified attribute.
Execute detailing of dimensions and dimension levels to set up navigation from dimension element to the object detailing its value. The command is executed in the left area.

To determine additional settings of sidehead structure:

Select the Row Headers checkbox in the additional structure settings area to display sidehead in table area. The checkbox is selected by default.
Set up element name displaying in form sidehead. To dot it, at the left area:

Select dimension.
Select the Names item in the dimension's context menu.
Select one or several dimension attributes, by selecting a checkbox next to the attribute.

NOTE. If several attributes are selected, each selected attribute will be displayed in table area in a separate column.

The example of additional attribute display

Select the Row Numbering checkbox in the area of additional structure setup for sidehead rows numbering. By default, row numbers will be displayed in a new sidehead column before headers. Numbering starts from rows containing data. To set up numbering, click the button, the Numbering dialog box opens. The setting is available when the Numbering of Rows checkbox is selected.

NOTE. Numbering by rows can be set up after creating table area on editing. To do this, select a cell or a cell range of table area and select the By Rows item of the Numbering button drop-down menu on the Table ribbon tab. To additionally set up numbering, select the Set Up item in the Numbering button drop-down menu of the Table ribbon tab, the Numbering dialog box opens.
Show or hide the numbering is available on working with ready form.

After the table area sidehead structure is set up, go to the Setting Up Indicators Structure step.

Setting Up Sidehead Dimension Elements

To set up sidehead elements:

Select elements displaying in table area sidehead by using dimension elements selection. The element selection in sidehead is available in left and right areas.

To select dimension elements from left area:

Select a group of elements in the Groups of Elements dimension context menu. Groups of elements selection is not a mandatory step.
Set selection of dimension elements. To do this:

Select the Edit item in the dimension's context menu.
Select the selection schema in the Selection Schema drop-down list in the dimension's context menu.

To set up selection by dimensions and dimension elements in the right area, if selection is not set to the left:

Set selection of dimension elements. To do this:

Select the Edit item in the dimension's context menu.
Click the button after selecting the dimension.

In the dialog box that opens select one of the filter options:

Filter options:

All Elements. All elements will be selected.
Selected Elements. Select only required elements or exclude selected elements from selection by selecting the Exclude Selected checkbox.

To search element in the list, start entering name of the searched element in the search field . When the entire word or its part are entered, the list displays the elements, which names contain the searched character combination:

To clear the search field, click the button.

Finish selection by clicking the Finish button.

To reset selection determined at the right area, select the Reset item in the dimension's context menu.

Select alternative hierarchy to display alternative dictionary elements, instead of the elements of the dictionary that is used to build a sidehead, or set up dynamic selection of alternative hierarchy depending on the parameter attribute by specifying alternative hierarchy option in the Alternative Hierarchies dialog box. To open the dialog box select the Alternative Hierarchies item in the dimension's context menu:

Set:

Alternative Hierarchy Type. Select the radio button of the required option: fixed, dynamic, or none. Alternative hierarchy is not applied by default.
Alternative Hierarchy Source. It depends on the selected type of alternative hierarchy:

If the Fixed type is selected, the alternative hierarchy source is a dictionary. Select a dictionary from the drop-down list or click the search button and start entering the dictionary name. Only one dictionary can be selected.
If the Dynamic type is selected, the alternative hierarchy source is parameter. Select a parameter attribute of data entry form in the drop-down list or click the search button and start entering the parameter name. When the dynamic type of alternative hierarchy is selected, the sidehead is rebuilt depending on the selected attribute value. If attribute value of the selected parameter element is not an alternative hierarchy key, the appropriate message is displayed. When this option is selected, the Selection Schema and Group of Elements options are not available even if grouping is available for this dimension.

TIP. For details about setting up dynamic selection of alternative hierarchy depending on parameter attribute, see the Setting Up Dynamic Changing of Displayed Sidehead Dimension Elements article.

If the None type is selected, the list is not available.

If dictionary or parameter attribute is not selected as an alternative hierarchy data source, clicking the OK button applies the main hierarchy.

If the dictionary attribute that was set as an alternative hierarchy key, is deleted, the first opening of the data entry form displays the message about deleting attribute and applying the main hierarchy for change.

Use the button to delete elements and dimensions selected in the right panel. It is possible to delete one or several dimensions and/or elements simultaneously. To select several dimensions and/or elements, use the SHIFT or CTRL keys.
Select the Dimension Name context menu item in the right area to restore the dimension deleted from the right area.

Execute these actions for each dimension.

NOTE. The Alternative Hierarchies, Selection Schema, Groups of Elements items are available if alternative hierarchies, selection schema, groups of elements are set up in dictionaries.

The order of alternative hierarchy, group of elements, selection schemas and advanced filter application

If on setting up sidehead dimension elements, the alternative hierarchy, group of elements, advanced filter and selection schema were selected, then they will be applied in the following order:

Alternative hierarchy.
Group of elements.
Advanced filter.
Selection schema.

Changing Dimension Positions

To change dimension position order in the sidehead, use the and buttons after selecting dimension at the left area.

Grouping Dimensions

Grouping of sidehead dimensions is applied to merge dimensions by specified attributes. Grouping is applied to elements of one dimension. If several dimensions are displayed in the sidehead, the first element of the next dimension will be displayed next to grouping element. If grouping is also set for the next dimension, the grouping element of the next dimension will be displayed. Grouping can be set up for each dimension displayed in the sidehead, except for the dimension, for which alternative hiearcrhy is set up.

Example for one-dimension sidehead

Example for multidimensional sidehead

To group dimensions:

Click the Group button to open the dialog box.

Select dimension or dimension attributes for grouping in the Sidehead Dimension area and move it using the button or dragging and dropping to the Grouped Attributes area. When attribute is moved, it will be deleted from the Sidehead Dimensions area and will be displayed in the Grouped Attributes area.
Delete attributes if there is no need to use them in grouping. To do this, select attribute in the Grouped Attributes area and move the using the button or Drag&Drop. If attribute is moved, it will be deleted from the Grouped Attributes area and will be displayed in the Sidehead Dimensions area.

Place attributes in the required order using the and buttons. The attributes location in the Grouped Attributes area affects the element order in the table sidehead. Several attributes can be moved at the same time.
Select the Hide Attribute Empty Values checkbox to show only the attributes with defined values. The checkbox is selected by default. It is required to hide empty attribute values if several attributes are not specified for elements. If empty attribute values are hidden, the table displays grouped elements and then ungrouped elements, that is, those without attribute values, by which grouping is set up.

The example of the Hide Attribute Empty Values checkbox use

Finish the grouping by clicking the OK button.

To set up aggregation for grouped elements, use aggregation block in the Calculation Algorithms tool.