Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Builder (PI Server 2024 R2)

Retrieve elements by browsing

  • Last UpdatedJan 11, 2023
  • 2 minute read

Before you can retrieve elements, you need to Specify a database.

You can use PI Builder to browse the element hierarchy in a PI AF database, and then select an element to retrieve into Microsoft Excel.

  1. On the PI Builder tab, click Elements > Browse Elements to open the Element Browser window.

  2. Navigate the element hierarchy by expanding parent elements.

  3. Select the element you want to retrieve into your worksheet and click OK.

  4. In the Select Object Types and Column Headers window, select the objects and column headers that you want to appear in the worksheet.

    Note: Use the Template field to retrieve attributes from a template. The attributes defined by the selected template are displayed in the Attributes Columns (from Template 'name') group in the Object Types list.

    If you want to retrieve:

    Then:

    Elements from all levels of the hierarchy into the worksheet

    Select the Child Elements check box from the Object Types list.

    Information about references to other elements

    Select the Element References check box from the Object Types list.

    Attributes into separate rows

    Select columns in the Attribute group.

    With attributes shown in rows, you can edit information about the attributes. See Show attributes in rows.

    Attributes in multiple columns

    Select columns in the Attribute Columns group.

    With attributes shown in columns, you can only edit the attribute value or configuration string. See Show attributes in columns.

    Analyses for the elements

    Select columns in the Analysis group.

    See Element columns for a list of available columns for elements.

  5. Click OK to retrieve the selected element into the worksheet and populate the selected columns with any data for that element.

TitleResults for “How to create a CRG?”Also Available in