General Attribute Properties

When creating or editing a standard or system attribute, set its properties in the Attribute Properties dialog box.

To open the dialog box on creating a general attribute:

In the web application select the Add > General Attribute item to create a general attribute. The Attribute Properties dialog box opens.
In the desktop application:

Execute one of the operations:

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

Select the General Attribute type. The Attribute Properties dialog box opens.

To open the dialog box on editing the general attribute, execute one of the operations:

In the web application click the Edit button.
In the desktop application:

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

Web application Desktop application

NOTE. System attributes do not allow editing some settings.

Set the parameters:

Name. Enter attribute name.

Identifier. Enter unique attribute identifier. Only Latin characters, numbers and underscores are allowed; spaces are not allowed.

Data Type. Select attribute data type in the drop-down list:

DateTime.
String.
Integer.
Real.
Date.
Logical.
Long text.

NOTE. Attributes of the Long Text type enable the use of a text string containing over 4000 characters.

Total Length. Determine the maximum length of attribute value. It is available only in for string and real data types.

Decimal Places. Determine the number of decimal places. It is available only for real data type. The specified number of decimal places should be less than the maximum length of attribute value specified in the Total Length parameter.

Available for Editing in the Element Card. In the drop-down list select when attribute value is available for edit in the element card:

Always. Attribute value can always be edited in the element card.
If Visible. It is used by default. Attribute value can be edited in the element card if the attribute is not hidden.
Never. Attribute value cannot be edited in the element card. Regardless of the state of the Hidden Attribute checkbox, the Null Values Allowed checkbox is selected and disabled.

Empty Values Allowed. The checkbox is selected by default. If the checkbox is deselected, each dictionary element must have the value of this attribute. Otherwise this attribute is optional. This option is available if the attribute is not hidden.

Multiple Values Allowed. The checkbox is deselected by default. If the checkbox is selected for the dictionary element, several values of this attribute can be set. The set of values of this attribute is displayed in a row separated by semicolons. To select several attribute values, one can set a link by this attribute with the other dictionary containing values. When working with data analysis and building reports tools one can save data to dictionaries with multiple attribute values if one specified this dictionary as a data source and cube dimension, on which various reports are created.

NOTE. If the Multiple Values Allowed checkbox is selected, the Alternative Hierarchy checkbox must be deselected because these checkboxes cannot be selected at the same time.

Hidden Attribute. When the checkbox is selected, the attribute is used in dictionary creation but is not displayed in the dictionary. The checkbox is available if the attribute may have empty value. Hidden attributes are highlighted in grey on the Attributes tab. Hidden attributes are not additionally highlighted.

Translate Value into Other Languages. The checkbox is selected by default. Selecting the checkbox enables the user to create a multilingual MDM dictionary. It stores names of all attributes and values of string attributes both for the current language and for the languages, into which this dictionary needs to be used.

NOTE. The checkbox is available only in the desktop application only for attributes of the String and the Long Text type if the Translate Dictionary into Other Languages checkbox is selected on the Description tab.

Element Icon. When the checkbox is selected, attribute value determines index of the icon for dictionary element. The checkbox is available if the object is set for repository that contains dimension element icons. If this attribute is selected, an icon index of which matches the value of this attribute, is displayed next to elements names. This checkbox is available only for integer attributes.

Alternative Hierarchy. The checkbox is deselected by default. If the checkbox is selected, the attribute is used to set up MDM dictionary's alternative hierarchy.

NOTE. If the Alternative Hierarchy checkbox is selected, the Multiple Values Allowed checkbox must be selected because these checkboxes cannot be selected at the same time.

Calculate Default Value. The checkbox is deselected by default. Set a fixed value or a Fore expression as a default value, using expression editor. Determine when the value is calculated: once on creating an element or every time the element is changed.

NOTE. Calculated value cannot be changed on editing dictionary element.

The Attribute Properties dialog box enables the user to edit attribute name and type for all system attributes. One can also change attribute visibility in the Hidden Attribute dictionary for all system attributes except for the Name (NAME) attribute. The Calculate Default Value option is available for the Name (NAME) attribute. In the Expression box set the formula used for creating an element name.