Retrieve units of measure for selected UOM classes

Before you can retrieve units of measure, you need to Specify a database.

You can use PI Builder to retrieve the units of measure (UOM) for selected UOM classes from a PI AF database into Microsoft Excel.

1. On the PI Builder tab, click Library > Units of Measure > Find UOM Classes to open the Unit-of-Measure Class Selection window.

   The Class list shows all the UOM classes in the PI AF database.

2. If desired, filter the list of UOM classes further:

   1. From the Filter list, select one type of filter: Contains, Exact Match, Starts With, Ends With.

   2. In the Filter field, type the text that you want to search for and press Enter.

   PI Builder returns the UOM classes that match the selected criteria.

3. Select one or more classes to retrieve and click OK.

4. 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 both the selected UOM classes and their UOMs into the worksheet.

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

   Note: PI Builder also retrieves the base class of selected UOM classes. For example, if you select the Area class, PI Builder also retrieves the Length class.