Mapping PDW Metadata Items to Multi-Valued or Multi-Branched Dictionary Items

When you define dictionary items, which are user-defined fields, you may need to create multiple values for one dictionary item. You may also need to create one dictionary item for many branches or territories. For such dictionary items, indicate to what value or branch/territory you are mapping a Metadata item.

For dictionary items with multiple values, indicate the value on the Export Maintenance screen. Dictionary items with multiple values are named separately in Dictionary Maintenance. When you enter the dictionary item to which to map the metadata item, you also enter the value.

For dictionary items with multiple branches or territories, indicate the branch or territory on the PDW Export Maintenance screen.

By mapping to individual properties in dictionary items, you can ensure that only the intended values or areas are updated.

For example: If you want to update pricing for a dictionary item, but that item exists in three branches and you only want to update the first branch, you would map the metadata item to the first branch of the dictionary item.

To map a metadata item to a branch or territory within a dictionary item:

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

In the Export Map field, select the export map containing the metadata that you want to map.
In the Eclipse Dictionary field, select the dictionary item to which you are mapping the metadata item.

Make sure that the metadata item you want to map to this dictionary item is in the matching PDW Meta Item field.

Double-click the Properties icon Use the Props hot key to display the PDW Meta Data Properties screen window.

Note: If a property option is already applied, the system displays an information icon: .

The system populates the following fields:

Field	Description
Eclipse Dictionary	Dictionary item.
Property	Either: Multi Value Pos – Indicates the dictionary item is multi-valued. Enter Br/Tr/All – Indicates that the dictionary item is branch-specific.
Setting	Do one of the following: For Multi Value Pos, view the value to which this item is mapped. For Enter Br/Tr/All, enter the branch, territory, or All to which you want to map this item. Note: Use the Delete Settings hot key to delete any incorrect mapping.

Save changes and return to PDW Export Maintenance.
Run the Eclipse Product File Batch Update.