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. |
In the Import Dimensions, Interface Load ID field, enter the load ID or click .
Tip: |
To enter multiple Load IDs separate each entry with a comma (,). |
The Load ID Selection dialog box is displayed.
In the list of available load IDs on the left, select a load ID to add and click .
To deselect a load ID from the list of selections, click .
Tip: |
To select all load IDs, click |