The Structure Page: Calculated Dictionary

The Structure page is used to create a logical structure of the future tree of elements.

Blocks

Block is a basic element of the whole dictionary structure. A block is a conditional element that provides all elements from one data source on creating a dictionary. A dictionary may include any number of blocks. All levels are positioned at the same level. Only simple blocks are created in a calculated dictionary. Filling of blocks with elements and building recursive blocks is executed on the program level in the application macro.

To create a block, select the Blocks element or title of already created block, then execute one of the operations:

In the web application click the Add Block button. The Block Properties panel opens.
In the desktop application click the Add Block button. The Block Properties dialog box opens.

Web application Desktop application

Set block properties:

Name. Enter block name. The default name: Block<number>.
Identifier. Enter unique block identifier. The default identifier: BLOCK<number>.

A primary index is created automatically for each block. This index will be used on building a dictionary to check for uniqueness and identify elements of this block only.

In the desktop application select the attribute in the list and execute one of the operations:

In the web application click the Delete button
In the desktop application click the Delete button.

The block will be deleted after confirmation.

Indexes

TIP. It is recommended to create a primary index in dictionary indexes and to include the attribute with the Indicator purpose to it, or any other attribute, by which there are unique values assumed. To ensure correct work of the dictionary, it is not recommended in the future to include attributes, by which empty values may be, into indexes.

To create an index, select the Indexes element in the Dictionary Blocks and Indexes area or inside any block, the execute one of the operations:

In the web application click the Add Index button. The Index Properties panel opens.
In the desktop application click the Add Index button. The Index Properties dialog box opens.

Web application Desktop application

Set index properties:

Name. Enter index name. The default name: Index<number>.
Identifier. Enter unique index identifier. Identifier can have only Latin letters, numbers and underline character. The default identifier: INDEX<number>.
Index Type. Determine index type. To do this, select the appropriate checkbox:

Unique. Unique index checks for uniqueness data by attributes, which will be included into the index.
Primary. Unique index that is used for element identification. The primary index ensures that a dictionary has only one element with a specific attribute value (combination of attribute values).

To set attributes, which values will be checked by the index on creating a dictionary:

Select the attribute in the Dictionary Attributes area.
Select the index in the Dictionary Blocks and Indexes area.
Click the Bind button in the web application or the Bind button in the desktop application.

After executing the operations the dictionary attribute is bound with the index.

To delete index, select its title in the list and execute one of the operations:

In the web application click the Delete button
In the desktop application click the Delete button.

The index will be deleted after confirmation.

Dictionary Structure

Blocks

Indexes