Non-Unique Keys: Composite MDM dictionary

The Non-Unique Keys page is used to create and set up non-unique keys.

A non unique key is an additional identifier of dictionary records. It is used to:

Set up attribute as an alternative hierarchy.
Set index to link with alternative hierarchies.

A key may contain:

A single dictionary attribute, which values can be repeated for each element.
Several attributes, which values are non-unique.

Operations with Non-Unique Keys

To add a non-unique key, click the Add button. A new key will be added to the list of non-unique keys. Key name and identifier will be set by default. The default value of the Name property - ITEM<Number>. The default value of the Identifier property is NUI<Number>.

Set non-unique key properties:

Name. Enter non-unique key name.
Identifier. Enter non-unique key identifier. Only Latin characters, numbers and underscores are allowed; spaces are not allowed.
Attribute Entries. The list contains checkboxes corresponding to all dictionary attributes. Select one or several attributes that must be included into a non-unique key.

To edit properties of the selected non-unique key, change properties in corresponding columns of the required non-unique key on the Non-Unique Keys page of the dictionary wizard.

To delete the selected non-unique key, click the Delete button. A confirmation to execute the operation is requested.

To change the number of displayed properties, click the Settings button and select or deselect the checkbox next to property names.

The function is available using the Fore language. A non-unique index in the dictionary's child table enables the user to execute queries quicker.

To create a non-unique index:

Create or get the existing non-unique key in the dictionary.
Cast the obtained key to the IMetaIndex interface.
Set the IMetaIndex.Enabled property to True.
Save changes.

As a result, a non-unique index is created in the dictionary's child table based on the non-unique key from the dictionary.

NOTE. If the non-unique key in the dictionary contains imported attributes or attributes with multiple values, a non-unique index cannot be created on its basis.

To get the example, see the Creating a Non-Unique Index in MDM Dictionary Table section.