Edit UOM group mappings

Before you can edit UOM group mappings, you need to Specify a database.

Beginning with PI AF 2017 R2, units of measure that are included as part of PI AF are mapped to UOM groups, such as Metric and US Customary. Once you have selected which UOM group you prefer to use at your location, you can display all attribute values with units of measure mapped to that UOM group rather than the default UOMs that are defined in attribute templates.

You can use PI Builder to create additional UOM groups, as well as edit UOM group mappings in Microsoft Excel and then publish the changes to PI AF.

1. On the PI Builder tab, click Library > Units of Measure > UOM Database.

2. In the Select Object Types and Column Headers window, select the objects and column headers to include in the worksheet, and then click OK.

   For example, from the Object Types list, select the UOMClass and UOM check boxes to retrieve all the unit-of-measure classes and the units of measures in the database.

   Note: If not already selected, select the UOMGroup check box.

   PI Builder retrieves all of the selected objects into the worksheet and fills the selected columns with available data.

   • UOM groups are identified by square brackets in the column heading, for example, [Metric] and [US Customary].

   • Mappings specified for each UOM in a given UOM group are shown at the intersection of the UOM’s row and the UOM group’s column.

3. Choose from the following actions:

   • You can rename, change descriptions of existing UOM groups, as well as add and delete them. When you add a UOM group, ensure the name is encased in square brackets.

   • You can add, edit, and delete UOM definitions and mappings.

4. On the PI Builder tab, click Publish.

5. In the Publish Options window, select Create and Edit from Edit Mode list and click OK.