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.