Create a multi-dictionary data structure

Multiple data dictionaries can be combined to form a multi-dictionary data structure. This type of data dictionary is defined similar to a star structure dictionary, except the world selection function is disabled and the metadata comes from the data dictionaries (not the databases).

After you specify the common data dictionary information, select the multi-dictionary data dictionary type and perform the following steps:

  1. On the Data structure page, select Multi-dictionary as your data dictionary type. The Data Structure tab is enabled.
  2. Select the Wizard button wizard icon graph with yellow plus sign. The Choose a table window displays.
  3. Select a specific Table (data dictionary) from drop-down list, then click OK. You will notice that only tables of type standard dictionary are available, you cannot create a multi-dictionary based on SQL dictionary.
  4. Specify the level of depth for your star model.
  5. Choose an option from the Import fields list. You can specify to import All the fields, All but keys or None. The star structure data dictionary is created when you click OK.
  6. Enter values for the basic data dictionary fields. See Build a data dictionary.
  7. Optionally, specify values for the fields under More Details:
  8. Field Description
    Max lines in memory

    Limits the number of lines retrieved from the database. Specify -1 for unlimited lines.

    Note   Please set this field to a value close to the actual number of records that you intend to monitor. Specifying a very high number or -1 (unlimited) will have a negative impact on the report's loading time. In order to avoid performance issues caused by overlooking this field, starting with Service Pack 7, the default value for a newly created Data Dictionary was set to 10000.

    Comment Add a comment to the data dictionary.
    Available for reports Determines if this dictionary can be used to set up a report.
    Available for tasks Determines if this dictionary can be used to set up a task.
    Version Version number of the object.

Related Links