Updating domains from an Excel file

You can modify the values of dynamic domains that are stored in an Excel file and update the BOM of your project with the new values.

Before you begin

You must use a new or existing change activity to update domains in projects that are using the governance framework in Decision Center.

About this task

When a project contains a dynamic domain defined in an Excel file, the Excel file is stored as a resource in the project. You can modify the Excel file and then upload the changes to Decision Center.

The Excel file has a specific structure with columns that map properties in the BOM:

A column for the domain values
A column for the label of each value
A column that defines the BOM-to-XOM mapping for each value

Other optional columns for the documentation or labels in other locales might be defined in the Excel file.

You can modify the values in each column, but you must not change the columns or column headings.

Procedure

To edit the Excel file:

In the Decision artifacts tab, in the Resources default folder, browse to the resource that corresponds to the Excel file.
If the Resources folder is not in the folders list, edit the artifacts filters to enable the Resources type.
Click the Excel file in the list to open the preview.
To download the file, click its name.
Open the Excel file, modify the values, and save the changes.
You can now upload the modified Excel file to Decision Center.
In the preview of your file in the Business console, click the edit button, and then click Refresh.
Select the new version of the file and click the save icon.
Open the Model tab.

This tab lists the domains of the project. You can expand a domain to see its current values and the updates that have been made in the Excel file.
To update the BOM with the new values, select the domains that you want to update and click Apply changes.
This process can take several minutes to complete if the domain contains many values.