When importing dimensions and members from interface tables, all dimensions and members are automatically imported. However, there is a i_Load_ID column in the interface tables that can act as a filter when running the import profile. 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.
To enter load IDs:
After you create an interface table import profile and click Yes to import the dimensions.
In the Load ID Input dialog box, enter the load IDs, separated by a comma or click to select the load IDs.
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. |