Add tables

You can select any number of tables from different data sources and add them to an analysis realm.

First, in the Add Table to Analysis Realm Wizard, you use a data connection to select a table to be added to the analysis realm. Then, in the table, you select the columns whose data is to be extracted and used as criteria in PPM. At the end, you use two criteria to link the new table with a table that already exists in the analysis realm.

You can import only a completely linked analysis realm into PPM. You create a completely linked analysis realm by adding individual tables one after another to the analysis realm and linking each of them with existing tables. You link two tables by selecting a criterion in one table with the same data type and the same values as the criterion in the other table. Therefore, you need to ensure that the tables you select have criteria meeting this requirement.

You can link the tables by using either the wizard or the Table links tab after you exit the wizard. If you want to link a new table with multiple tables you need to use the Table links tab.

Tables already added to the analysis realm are listed on the Analysis realm tables tab of the overview pate. Tables are displayed on the left including their names specified during configuration and the type of data connection. On the right, the configurations pertaining to a selected table are shown. This includes names of the table columns selected, description, data type in PPM, and the set criterion.

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. Click Edit.
  3. Click new_document_16.png Add table to analysis realm.

    Use the wizard that opens for selecting tables from a data source.

  4. Specify your settings.
  5. Click Finish.

The tables you select are added to the analysis realm and displayed on the Analysis realm tables tab.

Double-click a table in the list to edit it.

To remove a table from the analysis realm, select the table and click button_delete.png Remove table from analysis realm.

You can also link tables at a later time.