PI Asset Framework Data

PI Asset Framework Data interactive module dialog box can be accessed using PI tab in main menu. In Specifications tab, click Edit Parameters.

Option Description
PI Server This is a composite control in PI Asset Framework Data dialog box and it contains the following controls:
  • PI Server: Select this option to connect to the PI server.
  • PI Server show list: Click this button to display the list of PI servers. Use this dialog box to add or remove servers from the list.
  • PI Server Connect: Click this button to connect to the selected PI server.
Asset Framework Database This is a composite control in PI Asset Framework Data dialog box and it contains a dropdown list and show list button.
  • PI Asset Framework Database: Select this option to query the PI Asset Framework Database.
  • PI Asset Framework Database showlist: Click this button to display the list of PI Asset Framework databases. Use this dialog box to add or remove databases from the list.
Queries
  • Add: Click this button to save current query selections in the dialog box to the queries list.
  • Update: Click this button to update current query selections in the dialog box to the queries list.
  • Remove: Click this button to remove current query selections in the queries list.
  • List: Click this button to remove current query selections in the queries list.
Select Queries from Spreadsheet Click this button to read asset queries from Statistica spreadsheet. The queries read from spreadsheet opens in the query list.
Asset Attributes This list box displays selected assets. Attributes can be selected by clicking the respective Attribute. Multiple selections can be made by selecting separate attributes. After selection, the Attribute needs to be selected again to clear it. Information for you to query on an attribute is determined by the parameters that are enabled and the Method that is selected.
Search This is a composite control in PI Asset Framework Data dialog box and it contains Search button, Criteria section, and Results section.
  • Start Time: Use this textbox to enter start time using standard OSI date/type syntax.
  • End Time: Use this textbox to enter end time using standard OSI date/type syntax.
  • Span: Use this textbox to enter sample interval.
    • If specified in hours, minutes, seconds, or milliseconds, the time intervals will be evenly spaced UTC time intervals.
    • If specified in a longer interval, the interval types are interpreted using wall clock rules and are time zone dependent.
    Example: A span interval created with the string 24h means using an evenly spaced 24 Universal Time Coordinated (UTC) hour interval between each event.

    Example: A span interval created with the string 1d returns an interval shorter or longer than 24 hours if the interval encompasses a Daylight Savings Time change. The order of values returned will still be reflected by the Span, regardless of the interval sign.

    • When a positive interval is specified, the interval calculation begins at the earliest bounding time in the Span and applies the interval repeatedly in time ascending direction to generate the calculation intervals.
    • When a negative interval is specified, the interval calculation begins at the latest bounding time in the Span and applies the interval repeatedly in time descending direction to generate the calculation intervals.
    The order of values returned will still be reflected by the Span, regardless of the interval sign.
  • Summary Type: Select this option to determine a summary to compute for each interval over time range.
    • Total: This is a totalization over the time range.
    • Average: This is the average value over the time range.
    • Minimum: This is the minimum value over the time range.
    • Maximum: This is the maximum value over the time range.
    • Range: This is the range of values over the time range (Maximum-Minimum).
    • Standard Deviation: This is the standard deviation over the time range.
    • Population Standard Deviation: This is the population standard deviation over the time range.
    • Count: This is the sum of event count over the time range when calculation basis is event weighted. The sum of event time duration over the time range when calculation basis is time weighted.
    • Percent Good: This is the percent of data with good value during the calculation period. For time weighted calculations, the percentage is based on time. For event weighted calculations, the percent is based on event count.
    • All: A convenience for requesting all available summary calculations.
    • All For Non Numeric: A convenience for requesting all available summary calculations for non-numeric data.
  • Method: Select this option to return required timestamp.
    • Recorded Value: This method returns the timestamp, attribute, value, unit of measure, optional tag, and data status for the attribute, using the start time to define the time, unit of measure to define the output units of measure, and mode to determine the value to return when a value does not exist at the exact time specified.
    • Recorded Values: This method returns multiple timestamps, attributes, values, units of measures, optional tags, and data status for the attribute, using the start and end time to define the time range, the unit of measure to define the output units of measure, and the type to determine how the times and values of the returned end points are determined.
    • Interpolated Value: This method returns the timestamp, attribute, value, unit of measure, optional tag, and data status for the attribute using the start time to define the time and unit of measure to define the output units of measure.
    • Interpolated Values: This method returns multiple timestamps, attributes, interpolated values, units of measure, optional tag, and data status for the attribute, using the start and end time to define the time range and using the span to define the interval of the time range.
    • Summary Value: This method returns a timestamp, attribute, summary type, value, possible unit of measure for the attribute, possible tag, and data status, using the start and end time to define the time range, summary type (which specifies a summary to compute for each interval over the time range), and basis to specify the method of evaluating the data over the time range.

      Count and PercentGood are the only summary types supported on non-numeric attributes.

      Time-weighted totals are computed by integrating the rate tag values over the requested time range.

    • Generic: This method returns multiple timestamps, attributes, values, units of measure, possible tags, and data status for the attribute using the start and end time to define the time range, unit of measure to define the output units of measure.

      NB can be unspecified.

      NB, when specified, must be less than or equal to 100000.

    • Plot: This method returns multiple time stamps, attributes, values, units of measure, possible tags, and data status for the attribute, using the start and end time to define the time range, unit of measure to define the output units of measure.

      NB must be greater than 1.

      NB must be less than or equal to 100000.

  • Mode: Select this option to determine value to return when a value does not exist at the exact time specified.
    • Auto: This mode automatically determines the best retrieval mode.
    • AtOrBefore: This mode returns a recorded value at the passed time, or if no value exists at that time, returns the previously recorded value.
    • Before: This mode returns the first recorded value before the passed time.
    • AtOrAfter:This mode returns a recorded value at the passed time, or if no value exists at that time, the next recorded value.
    • After: This mode returns the first recorded value after the passed time.
    • Exact: This mode returns a recorded value at the passed time or returns an error if none exists.
  • Type: Select this option to determine the type of recorded values.
  • NB: Use this textbox to enter NB value. This value is used to define the number of intervals or points to return.
    • For the summary type of Plot Values the value defines the number of points to return. The number of points must be greater than 1 and less than or equal to 100000.
    • For the summary type of Generic the number of points must be greater than and less than or equal to 100000.
  • UOM: Select this option to determine a Unit of Measure.
  • Basis: Select this option to determine how summary value is calculated.
  • Filter: Enter a string containing a filter expression. Expression variables are relative to the attribute. A null or empty string indicates no filtering. If the attribute does not support the option filter, the filter will be ignored as if not specified.
Preview Data Click this button to preview data retrieved from executing the current query selections in the PI Asset Framework Data dialog box.
OK Click this button to return data from all currently available queries from the PI Asset Framework Data dialog box.