Insert a set of data items with a common structure into your worksheet

Asset-relative displays require the worksheet to contain set of data items (PI AF attributes) that have a common structure along with a root-path drop-down list for those data items.

1. Select a cell in the worksheet where you will insert the data items.

2. On the PI DataLink tab, select Search to open the Search tool.

3. Set the search scope, specify the data items you want to find, and select Search .

   For asset-relative displays, you want to find PI AF attributes that have a common parent element and the same attribute structure. These attributes might have the same attribute template. For example, you might find all the reactors at your facility.

4. Split the paths of the data items such that the assets for the display appear in the Root path column.

   Move the Data item length slider until the Root path column shows the unique elements for the listed attributes. Typically this will be at or near the Name only setting.

   

5. Select the data items that you want to insert into the worksheet.

6. Under Insert root paths in, select Drop-down list.

7. Select OK.

   PI DataLink inserts the unique data items into the worksheet below a drop-down list that contains the unique assets (from the root-path column).

   

   Note: PI DataLink inserts the list of root paths in column ALL of your worksheet. If that column contains data, PI DataLink inserts the paths in the next available column to the right.