To determine dictionary attribute properties, use the Attribute Properties side panel in the web application or the Attribute Properties dialog box in the desktop application.
NOTE. The Attribute Properties side panel and the Attribute Properties dialog box are available only in table dictionaries and calculated dictionaries.
Set attribute properties:
Name. Enter attribute name. Default name: Attribute<number>.
Identifier. Enter unique attribute identifier. The identifier must contain only Latin characters, numbers, the _ character, and it must not contain spaces and must not begin with the number. Default identifier: ATTR<number>.
Data Type. In the drop-down list select attribute data type. String data type is used by default.
Hidden. This checkbox is available for all attributes except for the attributes, which purpose is Name. When this checkbox is selected, the attribute is used to build a dictionary, but it is not displayed in the dictionary.
Attribute Purpose. The group of properties contains the checkboxes that correspond to attribute values:
Name. The attribute, which value is shown as an element name on opening the dictionary. One attribute must always have the Name purpose. When executing data aggregation the attribute must be the only one with the Name purpose in the attributes list.
Identifier. The attribute, which value is displayed as an element identifier and enables the user to select the element in a unique way. On the further use of the dictionary, values of this attribute will be used on creating various internal formulas. Identifiers will be also saved in tables for binding of particular data to particular dictionary elements. Identifier values should be unique in all sources, based on which a dictionary is built. The use of empty value as an identifier is not allowed as well. One attribute must always have the Identifier purpose. When executing data aggregation the attribute must be the only one with the Identifier purpose in the attributes list.
NOTE. If a dictionary was created in Foresight Analytics Platform or early versions of Prognoz Platform, for correct operation make sure that one of the directory attributes has the Identifier assignment.
Order. The attribute, which values are used for primary sorting on opening the dictionary. This attribute will be automatically included into the list on the Sorting wizard page. One attribute must always have the Order purpose. When executing data aggregation the attribute must be the only one with the Order purpose in the attributes list.
Element Icon. The attribute that determines the index of the icon displayed for the dictionary element. It is used if the repository is linked to a document, containing dimension element icons. If this attribute is defined, an icon index of which matches the value of this attribute, is displayed next to elements' names. The attribute is optional.
NOTE. In the web application this attribute purpose is available only for calculated dictionaries.
Alternative Hierarchy. The attribute is used to set up an alternative hierarchy. The attribute is optional.
NOTE. In the web application this attribute purpose is available only for calculated dictionaries.
Hierarchy. The group contains the checkboxes to create a hierarchical structure of table dictionary in the simplified mode:
Parent Key. Select the checkbox to determine an attribute, by which a parent element will be determined. The checkbox is deselected by default.
Parent Key Link. Select the checkbox to determine an attribute, which will determine the parent element, to which this element refers to. The checkbox is deselected by default.
Source Field. In the drop-down list select the source field to be linked with a dictionary attribute.
NOTE. The Hierarchy group of parameters is available only in the web application.
Steps to create hierarchical structure of table dictionary will be displayed in advanced mode and described in the Dictionary Hierarchy section.
See also:
Table Dictionary | Calendar Dictionary | Calculated Dictionary | Dictionary Attributes