Create columns in the target publish entity

Follow the procedure below to create a column in the target publish entity and link it to your scenario:

1. Create a column in the target publish entity.
2. Add a column to the scenario configuration.
3. Add a column to the Publish Price History worksheet.

Create a column in the target publish entity

1. From Zilliant's IQ Interface, navigate to the Configuration tab.
   Note

   Access to the Configuration tab is limited. If you can't access it, contact your administrator.

2. On the leftmost panel, in the General Configuration section, select Entities.
3. Select your target entity.
4. In the Fields section, select Add New Field.
5. Enter information or make selections to create a column.
6. Select Save.

Add a column to the scenario configuration

1. From the Price IQ Manager Dashboard, expand the Setup folder.
2. Select the Scenario Config workbook.
3. On the Scenario Params worksheet, verify that you've defined your target publish entity in the Publish Target Entity column for the needed scenario.
4. On the Fields worksheet, locate a row for a field you want to publish into your target entity.
5. In that row, in the Publish Target column, enter the system name of the column from the target entity.

Add a column to the Publish Price History worksheet

To add a column to the Publish Price History worksheet in the Negotiated Prices workbook:

1. From the Price IQ Manager Dashboard, select Negotiated Prices.
2. On the Publish Price History worksheet, select Column and KPI Settings.
3. On the Column tab, select Manage Columns, then select Add missing fields.
4. Select Show for the needed column from the target entity.

The application will populate the new column on the Publish Price History worksheet after you optimize prices in your scenario.