Alternative Hierarchy based on Dictionaries

Any other dictionary can be used as an alternative hierarchy. A connection is set between the two dictionaries to map their elements. By default the mapping is executed by identifier and type of source and alternative dictionary attributes.

After using the alternative hierarchy, the alternative dictionary elements that are mapped by index are displayed instead of the source dictionary elements.

NOTE. Adding and removing of MDM dictionary elements included into group of elements, and also using of groups of elements in various operations does not depend on whether default hierarchy is selected. Groups of elements of MDM dictionaries work only with main dictionary elements. It is unavailable to create a group go elements on default alternative hierarchies.

To set up alternative hierarchies based on a dictionary, use the Alternative Hierarchies dialog box.

Select the Alternative Hierarchies dictionary's context menu item in the object navigator.

To create an alternative hierarchy:

In the Alternative Hierarchies area:

Click the Add button.
Press the INSERT key.
Select the Add item in the context menu of the field or hierarchy.

After executing one of the operations select the required dictionaries in the Select Object standard dialog box.

In the Index of Alternative Hierarchy drop-down list select a dictionary index, by which the link with another dictionary is set. The drop-down list contains all available indexes of the dictionary, for which the alternative hierarchies are set up.
The Source Dictionary field displays the name of the dictionary with which the hierarchy is linked. Clicking the Find Object button transfers the focus in the object navigator dialog box to the specified dictionary.
In the Index of Alternative Hierarchy drop-down list select a dictionary index, by which the link with the source dictionary is set.
In the Attribute Bindings field bind attribute of the source and alternative dictionaries. The table contains a list of attribute bindings of the source and alternative dictionaries. On adding alternative hierarchy, attributes are bound automatically: attributes with the same identifiers are bound. Attributes in the Alternative Dictionary column are edited by means of drop-down lists embedded in cells. The lists contain the attributes of the alternative dictionary that match by type with the corresponding attribute of the source dictionary.

To rename alternative hierarchy selected in the Alternative Hierarchies field:

Select the Rename item in the hierarchy's context menu.
Double-click the hierarchy.

The hierarchy name becomes available to edit.

To delete alternative hierarchy selected in the Alternative Hierarchies field:

Select the Delete item in the hierarchy context menu.
Press CTRL + DELETE.
Click the Delete button.

To delete all alternative hierarchies from the list without confirmation, select the Clear item in the context menu of the Alternative Hierarchies field.

Working with Alternative Hierarchy based on Dictionaries

After setting up alternative hierarchy for the dictionary open it for view. For its elements and for elements of a dimension based on this dictionary with alternative hierarchy the context menu displays the Alternative Hierarchy additional submenu:

To select alternative hierarchy, select an item, that matches the hierarchy name, in the Alternative Hierarchy submenu.

If there are more than ten alternative hierarchies determined for the dictionary, the Alternative Hierarchy submenu displays the Select Another Hierarchy item. Selecting this item opens the Select Alternative Hierarchy dialog box that includes the list of all alternative hierarchies available in the dictionary:

The current alternative dictionary hierarchy is selected in this list. To select another alternative hierarchy, select it from the list and:

Click the Select button.
Double-click on the hierarchy.

To set main hierarchy of a dictionary, select the Reset item in the Alternative Hierarchy submenu. This item is available, if an alternative hierarchy is defined for a dictionary.

If there are more than ten alternative hierarchies determined for the dictionary, the main hierarchy can be set by means of the Select Alternative Hierarchy window, by selecting the None item.

Example of Using Alternative Hierarchy based on Dictionaries

Consider a Territories table MDM dictionary that is classified by economic areas:

As alternative hierarchy the dictionary which is classified by federal districts is used.

After executing one of the operations select the Federal Districts table MDM dictionary in the Select Object standard dialog box.