Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

ADD A NEW IDEA

Clear

Ideas

Showing 38 of 5194

Table-Valued Function

Currently it is not possible to define filter definitions for Table-Value functions.With DataLink I'm able to define to build an average for a process value by using a defined filter method. e.g. calculating an average current of an engine while t...
Christian Benitz about 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

Add support for unit conversion

Please add a "Canonical UOM Per UOM" or "UOM Per Canonical UOM" column (not necessarily with those exact names) to the UnitOfMeasure table. This column would contain the conversion factor needed to convert between the UOM and the canonical UOM, si...
Kenneth Barber over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

Add RTQP PI SQL support for parameter type cast

PI DAS (RTQP Engine) 2018 SP3 Patch 1 lacks support for type casting input parameters of a table valued function. For example. this simple example fails to create a table valued function: CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDat...
Guest over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

Add RTQP PI SQL support for default value of function parameter

The current version of PI DAS (RTQP Engine) does not support the definition of default values for table-valued function parameters. This is a rather bleak omission, in my view. For example, the following will fail to create the table-valued functi...
Guest over 3 years ago in AVEVA™ PI System Access (PSA) / PI SQL Client 0 No status

New start-up parameter /SYNC_TIME defining a floating-window during which the interface will keep a RDB table in sync with PI data archive

The new RDBMSPI param:  /SYNC_TIME=rel_start_time,rel_end_time   for instance /SYNC_TIME=*-6h,*+1h When set, the interface: - after each execution of a query, which shall have the same "floating" window in its WHERE clause; for insta...
Guest over 3 years ago in PI Interfaces / PI Interface for RDBMS 1 No status

Accept the dd-mmm-yyyy format in the absolute time syntax for history recovery start and end times

The PI Interface for RDBMS currently accepts the format dd-mmm-yy but not the format dd-mmm-yyyy for history recovery start and end times. The former format lacks the century, so the year is ambiguous. The latter format solves this problem and so...
Kenneth Barber over 3 years ago in PI Interfaces / PI Interface for RDBMS 0 No status

History recovery from multiple tags with one output tag

I have a scan-based output point writing multiple PI values to the relational database as described here: https://livelibrary.osisoft.com/LiveLibrary/content/en/int-rdbms-v4/GUID-1A194D2B-388B-4FD7-8B82-D85EDDBBC572 I would like to perform histo...
Guest over 3 years ago in PI Interfaces / PI Interface for RDBMS 0 No status

Improved handling of PIBUFSS initialization

We have encountered a situation where we were unable to write out-of-order data to PI through the buffer subsystem from an interface, apparently because the buffer subsystem was not yet fully initialized when the interface connected to it. Please ...
Guest over 3 years ago in PI Interfaces / PI Interface for RDBMS 0 No status