Entering Load ID Information When Importing Dimensions

When importing dimensions and members from interface tables, all dimensions and members are automatically imported. However, there is an i_Load_ID column in the interface tables that can act as a filter when importing dimensions. Your database administrator can populate the i_Load_ID column in the database to enable you to filter the dimensions and members imported. In Performance Management Architect, you can enter a load ID when you create an import profile or import dimensions to filter artifacts from the interface tables so you do not load erroneous metadata.

Note:

The i_Load_ID column must be populated in the interface table by the database administrator before you can select them in Performance Management Architect.

  To enter loadID information:

  1. In the Import Dimensions, Interface Load ID field, enter the load ID or click Click to browse for Load IDs..

    Tip:

    To enter multiple Load IDs separate each entry with a comma (,).

    The Load ID Selection dialog box is displayed.

  2. In the list of available load IDs on the left, select a load ID to add and click Select Button.

  3. To deselect a load ID from the list of selections, click Remove Button.

    Tip:

    To select all load IDs, click Add all load IDs.. To deselect all load IDs from the list of selections, click Remove All Button.

  4. Click OK.