MDM Dictionary

The dictionary is used for creating a structured data view with the ability of its transformation. Creating a dictionary does not require a data source. Data can be entered manually or loaded from the data source to the dictionary by means of the built-in ETL tools. Dictionary elements may change in time, that is, may have several versions. Creating an MDM dictionary requires a database to store dictionary data. An MDM dictionary uses a single table to store data. A table is created automatically on creating a dictionary and is the dictionary's child object. Table fields correspond to dictionary attributes.

IMPORTANT. An MDM dictionary for storing attachments is created during standard cube setup and is filled in automatically. It is prohibited to create and edit such a dictionary manually.

Create an MDM dictionary

The wizard contains the pages:

Basic Settings. The page is used to set dictionary name, identifier, comment and other dictionary basic settings.
Database. The page is used to select a database to store dictionary data.
Attributes. The page is used to create a list of dictionary attributes.
Parameters. The page is used to create a list of dictionary parameters.
Links. The page is used to set up links between attributes.
Unique Keys. The page is used to set up basic identifiers for composite MDM dictionary records.
Non-Unique Keys. The page is used to set up additional identifiers for composite MDM dictionary records.
Levels. The page is used to set up data aggregation levels.

Selection Schemas. Selection schemas are set for automatic selection of dictionary elements by specified rules. Going to the page is available after saving dictionary settings.
Groups of Elements. Groups of elements are determined to limit the number of available dictionary elements. Going to the page is available after saving dictionary settings.
Alternative Hierarchies. The page is used to set links to map source and alternative dictionary elements. Going to the page is available after saving dictionary settings.
Manage Parameters. The page is used to set up parameters of nested objects related to the dictionary.

Access Subjects. The page is used to create a list of access subjects.

To save settings in the dictionary wizard:

Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After the command is executed, the specified settings are saved, the wizard closes, and the dictionary opens in the edit mode.

NOTE. The Save and Close item is available only on editing the settings.

Composite MDM dictionary structure is set up when creating a new composite MDM dictionary in the wizard and may be changed when editing the existing composite MDM dictionary.

For details about working with MDM dictionaries see the Working with Dictionary section.