Mapping Multiple PDW Metadata Items to One Eclipse Dictionary Item

In Export Map Maintenance, in order to map multiple metadata items to one dictionary item, you must assign priorities to the metadata items so that the system knows which item to export when both exist in the same Product Data Warehouse (PDW) product record. Enter each metadata item on a separate line in order to assign separate priorities.

For example: If the TMS DiscClass, TMS Mfg. Name, and TMS Lynx ID metadata items were mapped to the BUY.LINE dictionary item, you would assign these metadata items priority numbers. If you assigned TMS DiscClass a priority of 99, TMS Mfg. Name a priority of 98, and TMS Lynx ID a priority of 97, then, where all three metadata items existed in a PDW product file, the system would write the TMS DiscClass with the priority of 99 to BUY.LINE since it has the highest priority number. See below.

To map multiple metadata items to one dictionary item:

  1. From the Tools > Product Data Warehouse (PDW)> PDW Export Maps menu, select PDW Data Export Map Maintenance to display the PDW Export Data Maintenance screen.

  1. In the Export Map field, enter the ID for the map you want to edit.

  2. In the Eclipse Dictionary column, select or enter the dictionary item to which you want to map the metadata items.

  3. In the PDW MetaData Item column, enter one of the metadata items that you want to map to the dictionary item.

  4. Again in the Eclipse Dictionary column, enter the same dictionary item to which you are mapping the multiple metadata items.

  5. In the PDW MetaData Item column, enter another metadata item that you want to map to the dictionary item.

  6. Repeat this process until you have mapped all of the necessary metadata items to the one dictionary item.

  7. In the Pr column, assign a priority to each metadata item.

The higher numbers have higher priority, and the system exports the metadata item with the highest priority when several of the mapped metadata items exist in the same PDW product record.

  1. After you have mapped all necessary data elements to dictionary items, press Esc to save changes and exit the screen.

  2. Run the Eclipse Product File Batch Update.

See Also:

Mapping PDW Data Elements to Eclipse Dictionary Items

Creating Override Maps for PDW Product Exports

Viewing Sample Data for PDW Exports

Tasks Not Available in Solar