PI Summary Data

 

Use the options in this dialog box to return a data set (spreadsheet), that uses the timestamps, summary, and calculation basis parameters to return summary values from the archive.

 

On the Ribbon bar, select the PI tab > Data group > Summary to display the Summary Data dialog box.

 

You can also select the Home tab > File group. Click the Open arrow. From the Open External Data > PI submenu, select Summary Data to display the Summary dialog box.

 

 

In Classic menus, on the File > Get External Data > PI submenu, select Summary Data to display the Summary Data dialog box.  

 

To begin:

    1. Click the PI Logon button to display the PI Connection Manager.

    2. Log on to the PI server.

    3. Click the Tag Search button to display the Tag Search dialog. (The Tag Search dialog is an OSISoft UI component and is outside the scope of this documentation)

OK

Click OK button to begin the specified search.

Cancel

Click Cancel button to close this dialog box without conducting the specified search.

Search Tags

After you have completed the tag search, the tags you have selected will be returned to this list box. Click OK to query the PI database. Values will be returned for the tags in the box.

Load

Click the Load button to display the Search Tags list.

Save

Click the Save button to display the Save Tag Selections dialog box, where you can save the Search Tags list in a .ini file for easy retrieval.

Begin Date

 In this box, enter the begin date for the search.

You can enter the data manually, or click the Timestamp button to display a calendar where you can specify the date. Additionally, you can enter PI custom time intervals.

End Date

In this box, enter the end date for the search.

You can enter the data manually or click the Timestamp button to display a calendar where you can specify the date. Additionally, you can enter PI custom time intervals.

n Observations

Enter the number of observations to return in this box.

Use Sampling Interval

This check box (adjacent to n observations) toggles n Observations to Sampling Interval.

Sampling Interval

 In this box, enter PI custom time intervals. Sampling intervals need to be a string specified in hours, minutes, or seconds. Several formats are allowed: 1h, 2m, 35s, -2h, -5s, 01:30, 06:30:45.

Summary

Select the type of summary data you want to retrieve using the options in this list box.

NOTE: The values returned depend on the Calculation Basis selected.

A variety of summary types is available:

    • Total returns the sum total over the specified time range. It is the only summary type that supports non-numeric tags (i.e., string or digital tags).

    • Minimum returns the minimum value over the specified time range.

    • Maximum returns the maximum value over the specified time range.

    • Standard Deviation returns the standard deviation over the specified time range.

    • Range returns the range over the specified time range.

    • Average returns the average value over the specified time range.

    • Population Standard Deviation returns the population standard deviation over the specified time range.

    • Event Weighted Count returns the sum of the event count over the specified time range. It returns the sum of event time duration over the specified time range.

    • All returns the previously defined Total, minimum, maximum, range, standard deviation, population standard deviation, average, and count.

    • Min, Max, Range returns the previously defined minimum, maximum, and range.

    • Total and Average returns the previously defined Total and Average.

    • Std. Dev and Average returns the previously defined Standard Deviation and Average.

Calculation Basis

Select when performing the summary calculations. The calculation bases available are listed below:

      • Time Weighted weights the values in the calculation by the time over which they apply. Interpolation is based on the step attribute of the point, and when necessary, interpolated events are generated at the boundaries.

      • Event Weighted assigns equal weighting for each event without interpolation. At least one event must exist within the time range for it to perform a successful calculation. A minimum of two events are required for the standard deviation summary type.

In handling events at the boundary of the calculation, Statistica uses the following OPC standard:

    1. Use events at both boundaries when there is only one calculation interval.

    2. Include events at start time in multiple intervals when intervals are in ascending time order.

    3. Include events at the end time in multiple intervals when intervals are in descending time order.

      • Time Weighted Continuous uses the same weighting technique as Time Weighted; however, interpolation between values is performed as if they represent continuous data. Standard interpolation is used regardless of the step attribute of the point.

      • Time Weighted Discrete uses the same weighting technique as Time Weighted; however, interpolation between values is performed as if they represent discrete, unrelated values (stair step plot) regardless of the step attribute of the point.

      • Event Weighted Exclude Most Recent Event uses the same weighting technique as Event Weighted, except for how it handles events at the boundary of summary intervals in a multiple intervals calculation. Use this option to prevent events at the intervals boundary from being counted at both intervals. With this option, events at the end time (most recent event) of an interval are not used in that interval.

      • Event Weighted Exclude Earliest Event uses the same weighting technique as Event Weighted, except for how it handles events at the boundary of summary intervals in a multiple intervals calculation. Use this option to exclude events at the start time (earliest event) of an interval.

      • Event Weighted Include Both Ends uses events at both ends of the interval boundaries in the calculation.

Metadata Var

Select this check box to include a metadata variable in the resulting data set. This variable will indicate whether the data are good or bad. When this option is cleared, bad data are automatically filtered (excluded) from the resulting spreadsheet.

PI Logon

Click this button to display the PI Connection Manager and log on to the PI database.

Tag Search

Click this button to display the Tag Search dialog box, which is used to conduct a basic, advanced, or alias search. The results of this search will be used to populate the Search Tags list box.

Batch Search

Click this button to display the Batch Search dialog box, which is used to query the PI SDK server, using the PI batch search capability to automatically select sets of tags and date ranges from previously defined batch data in the PI system and to select one or many batches from a list.