Use Product Data Warehouse (PDW) user-defined files to populate PDW Translation Tables in an efficient, maintainable, and reportable manner. Instead of maintaining elaborate translation tables in PDW Export Maintenance, the translation table can point to a user-defined file containing cross-reference information.
For example, you can use PDW user-defined files to translate a vendor ID or discount class into an Eclipse buy line or price line.
In Export Maintenance, replace the translation table setup by Step 5 in the procedure below.
The key to the file (vendor number) equates to the translation table's From Value column.
The data you are entering equates to the translation table's To Value column.
This process can be repeated, but always create dictionary items for as many values as necessary. One file can be used for many values.
To use PDW user-defined files with Mass Load:
From the Tools > Product Data Warehouse (PDW) menu, select PDW Meta Maintenance to display the PDW MetaData Maintenance screen.
In the
Attach the file to the metadata item.
Each unique value in the listed metadata item is then created as the key to an empty record in the selected file.
For example, if you create a metadata item for vendor numbers and you attach a user-defined file to it, then every unique vendor number becomes a record in the user-defined file.
After creating the empty records in the file by attaching the file to the metadata item, create a dictionary item for the data you want to load into the file. Point this dictionary item at the file's attribute where the data should be stored.
Populate the file using Eclipse Mass Load.
For example, use the vendor number as the key to a price line. Use Mass Load to import the price line into the record corresponding to its proper vendor number.
Note: If you are populating the files created by the I2 data loads, make sure that the attributes you load with data are not the attributes being used by the data provided by the import.
To apply a user-defined file to an Export Map:
From the Tools > Product Data Warehouse (PDW) > PDW Export Maps menu, select PDW Data Export Maps to display the PDW Export Maintenance screen.
In the Export Map field, enter the ID of the map to which to apply the user-defined file.
In the Eclipse Dictionary column, select the dictionary item to be populated.
In the matching PDW MetaData Item column, enter the metadata item with which you want to populate the dictionary item.
Use the Translation
Use the Enter
Formula
In the Data Element column, enter the dictionary item for the value you want to capture.
See Also: