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 deleting MDM dictionary elements included in groups of elements, and the use of groups of elements in varuious operations do not depend on whether the 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 page of the dictionary creation wizard in the web application or the Alternative Hierarchies dialog box in the desktop application.

The Alternative Hierarchies page contains the operations:

Creation and general setup of alternative hierarchy

Delete alternative hierarchy

Open the Alternative Hierarchies dialog box

The Alternative Hierarchies dialog box contains the operations:

Creation and general setup of alternative hierarchy

Rename alternative hierarchy

Delete alternative hierarchy

Delete all alternative hierarchies of a dictionary

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 the dimension based on this dictionary with alternative hierarchy the context menu in the desktop application displays the Alternative Hierarchy additional submenu:

Operations with dictionary alternative hierarchy:

Select alternative hierarchy

Cancel using alternative hierarchy

Example of Using Alternative Hierarchy based on Dictionaries

Consider the Territories MDM dictionary that is classified by economic areas:

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

Execute the following steps:

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

  2. Add the Federal Districts MDM dictionary in the Alternative Hierarchies area. To do this:

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

  1. Set up a link between dictionaries and bind attributes:

  1. Click the OK button to save settings.

  2. In the object navigator open the Territories MDM dictionary for view and select the Alternative Hierarchy > Federal Districts item in the dictionary's context menu. As a result of alternative hierarchy use, instead of the Territories MDM dictionary elements, the Federal Districts MDM dictionary elements compared by index will be displayed:

See also:

Managing Dictionary Hierarchy | Alternative Hierarchy based on Dictionary Attributes