Using the Import Format Builder

When the source system is a file-based data load, use the Import Format Builder feature to map source fields graphically to target dimension members instead of typing the starting position and the field length. This feature is available for both fixed and delimited files.

Note:

The Import Format Builder does not support tab delimited files.

To assign an import format using the Import Format Builder:

1. On the Setup tab, under Integration Setup, select Import Format.
2. In the Import Format summary grid, select a file-based source system.
3. In the Import Format Mapping detail grid, click Build Format.
4. In Select file to Load, locate and choose the file to import, and then click OK.
   In addition to selecting a file to load, you can:

   • Create a new folder under the inbox directory.
   • Delete a file.
   • Download a file
   • Upload a file

   The file contents are shown on the Import Format Builder screen.

   
   
   
5. Select the text to import.
6. In Assign selected text as Source Dimension Name, select N to specify the source dimension name on the Enter Dimension Mapping Detail screen.

   Select Y to use the selected text as the source dimension name and to use the one-to-one mapping between the source dimension and target dimension members.

7. To change dimension mappings details, click Assign Dimension.

   You must add or change dimension details if you selected N in Assign selected text as Source Dimension Name.

   
   
   
8. On Enter Dimension Mapping Details, from Source Dimension Name, specify the name of source dimension to which to assign the selected text.
9. In Select Target Dimension, select the target dimension to which to map the source dimension.
10. In Selection Field Number, specify the field number from the file to import (defaults to the field number from the file when text is selected).
11. Click OK.

    When you assign or change source dimension information, the information is shown in the Add New Mapping summary grid.