Link tables

You can configure table associations for each analysis realm by linking specific criteria of the different tables.

When configuring the associations, please observe the restrictions described in chapter Restrictions and special cases.

The associations configured are displayed in graphical form on the Table links tab. In the upper part of the tab, the tables are shown as labeled rectangles and tables that are already linked are combined into blocks. If the bar contains multiple blocks the analysis realm has more, independent associations. Unlinked tables of the analysis realm are shown as one block. If you properly and completely associated all tables, they should all be combined into a single block.

To create a completely linked analysis realm, you can link the individual tables with blocks, and then the blocks with each other until all tables are combined into one block.

The lower part of the tab displays the criteria that were used for linking the individual tables.

Procedure

  1. Double-click an analysis realm in the Analysis realms of the client list.

    The overview page of the analysis realm is displayed.

  2. Display the Table links tab.
  3. In the upper part of the tab, double-click a rectangle with the name of the table that you want to link.

    The Change table links dialog is displayed that you can use for selecting the association criteria for linking the table.

  4. Specify your settings.
  5. Click OK.
  6. Click Save.

Linked tables are combined in one block. Your analysis realm configuration was saved.

To delete a table link, select a table in the upper area, then click Delete in a link row in the lower area.

You can run a validity check for your analysis realm configuration.