MDM Dictionary

The dictionary is used for creating a structured data view with possibility 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 that uses a single table to store information. A table is created automatically on creating a dictionary and is the dictionary child object. The table fields correspond to the dictionary attributes.

IMPORTANT. An MDM dictionary to store attachments is created during standard cube setup and is filled in automatically. It is prohibited to create and edit the dictionary manually.

The MDM dictionary wizard is different in the web application and in the desktop application.

Create an MDM dictionary

The wizard contains the pages:

  • Selection Schema. 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. Links are set to map source and alternative dictionary elements. Going to the page is available after saving dictionary settings.

The wizard contains the pages:

Setting Up Dictionary Structure

Setting up MDM dictionary structure is different in the web application and in the desktop application:

To set up dictionary structure, follow the steps:

  1. Set basic dictionary settings.

  2. Select the dictionary database.

  3. Add attributes.

  4. Add parameters if required.

  5. Create links if required.

  6. Add unique keys if required.

  7. Add non-unique keys if required.

  8. Create import and export schemas if required. It is available only in the desktop application.

  9. Create levels if required.

  10. Set up selection schema to automate element selection by specified rules. Going to the page is available after saving dictionary settings.

  11. Determine element groups to limit the list of available dictionary elements. Going to the page is available after saving dictionary settings.

  12. Set up alternative hierarchies. Going to the page is available after saving dictionary settings.

  13. Manage nested elements parameters if required. It is available only in the desktop application.

  14. Manage access subjects if required. It is available only in the desktop application.

  15. Select data source for composite table MDM dictionary wizard. It is available only in the desktop application.

  16. Replace predefined dialog box view if required. It is available only in the desktop application.

  17. Translate dictionary into other languages if required. It is available only in the desktop application. For details about setting up multilingual options of repository contents and system in general, see the Setting Up Multilingual Options

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

See also:

Creating Dictionaries | Composite MDM Dictionary