Adding Attributes

Attributes determine a set of characteristics that each dictionary element will have.

There are the following types of attributes:

System - required attributes of MDM dictionary that must not be deleted.
On creating an MDM dictionary the Attributes tab already contains a basic set of system attributes:

Key (KEY).

NOTE. MDM dictionaries support element keys within the range 0-2 billions.

Name (NAME).

NOTE. A value by formula can be created for the Name (NAME) attribute.

Order (ORD).
Owner (PARENT_KEY). The attribute is added automatically on selecting the Elements Have Hierarchy checkbox.
Source Dictionary (SOURCEDICTIONARY). The attribute stores source dictionary key (KEY). The attribute is available only in a composite table MDM dictionary. It is filled in automatically.
Source Element (SOURCEELEMENT). The attribute stores key (KEY) of source dictionary element. The attribute is available only in a composite table MDM dictionary. It is filled in automatically.
Version (VERSION). The attribute is added automatically when the Elements can Change in Time checkbox is selected.
Start Date (INDATE). The attribute is added automatically when the Elements can Change in Time checkbox is selected. The default start date is 01.01.1900.
End Date (OUTDATE). The attribute is added automatically when the Elements can Change in Time checkbox is selected. The default end date is 31.12.2999.
Hide (HIDDEN). The attribute is added automatically on selecting the Elements Have Hidden Attribute checkbox.
Read Permission (READACCESS). The attribute is added automatically on selecting the Elements Have Discretionary Access Permissions checkbox.
Edit Permission (WRITEACCESS). The attribute is added automatically on selecting the Elements Have Discretionary Access Permissions checkbox
Delete Permission (DELETEACCESS). The attribute is added automatically on selecting the Elements Have Discretionary Access Permissions checkbox.
Permission to Edit Permissions (ACCESSACCESS). The attribute is added automatically on selecting the Elements Have Discretionary Access Permissions checkbox.
Mandatory Access Control (MANDATORYACCESS). The attribute is added automatically on selecting the Elements Have Mandatory Access Control checkbox.

All system attributes on the Attributes tab are highlighted in green. The set of system attributes may vary depending on the parameters specified on the Description tab.

Custom - MDM dictionary attributes that are set by the user.

Standard - they are used to create MDM dictionary fields.
Imported - they are used to create MDM dictionary fields, which values are imported from linked dictionary.

NOTE. When working with data analysis and report building tools data cannot be saved to dictionaries with multiple values of imported attribute.

To create and set up MDM dictionary attributes, use the Attributes tab.

To open the tab

If the Translate Dictionary Into Other Languages checkbox is selected, the icons of attributes of the String and Long Text types requiring translation are replaced with the flag of the country that uses the current translation language as its official language.

Operations with Dictionary Attributes

To add a dictionary attribute:

Execute one of the operations:

Click the Add button.
Open the context menu on free area of the Attributes tab.
Double-click the main mouse button on free area of the Attributes tab.

Select attribute type:

Standard Attribute. The Attribute Properties dialog box opens.
Imported Attribute. The Imported Attribute Properties dialog box opens. An imported attribute can be created if the link with another dictionary is established.

The attribute of selected type will be added to the dictionary.

To edit properties of the selected dictionary attribute:

Click the Edit button.
Select the Edit item in the attribute's context menu.
Double-click the attribute name with the main mouse button.

Enter required modifications into the Attribute Properties or Imported Attribute Properties dialog box.

To reorder attributes in the dictionary list:

Use the Up and Down buttons.
Select the Move Up/ Move Down item in the attribute's context menu.

After attributes are reordered, fields of the current MDM dictionary are automatically reordered.

To delete the selected attribute:

Click the Delete button.
Press CTRL + DELETE.
Select the Delete item in the attribute's context menu.

It is requested to confirm the executed operation. To delete the attribute that is used in the parameter, unique or non-unique key, first delete the parameter or key.