Allow substitution parameters to be used in the SELECT and FROM clauses of the TableLookup Data Reference
As a user, I would like TableLookup Data Reference to be able to use substitution parameters to specify the column name(s) and table name for the SELECT and FROM fields respectively. This would allow for the use of attribute values like those from...
Add more advanced string handling functions to the String Builder data reference
I would like to use some more advanced string functions such as Split, Len (string length), and even regex filtering to allow more fine grained control of how some input strings (such as attribute values or substitution parameters) are manipulated...
If you have a PI Point attribute with auto tag creation and you want the attribute UOM and PI Point engunits to match, you have to define it twice; once in the attribute UOM field and a second in the attribute configuration string, e.g. engunits=m...
Enable the ability of the Analyses to recalculate the most recent exeuction. When manually entered data is utilized in an AF Analyses, under a variety of analysis configurations, the most likely analysis execution needing to be recalculated is the...
Easily deploying and maintaining AF objects in multiple remote AF databases
Originally posted on PI Square at https://pisquare.osisoft.com/ideas/5538-easily-deploying-and-maintaining-af-objects-in-multiple-remote-af-databases
Today, one of the method that can be used to selectively reconcile object changes (including tem...
Allow substitution parameters in attribute template description
As a user, I want to be able to use substitution parameters in attribute template descriptions, so that when elements are created from template, the attribute template description can be substituted with pertinent information.
Note: This was prev...
Executing query or stored procedure directly from AF analysis
Currently you can add a query or stored procedure to the library in AF. From there you can retrieve data to be used in an attribute via table lookup. What I am looking for however, is to be able to directly execute a stored procedure from an analy...
Add IsExcluded('attribute') function to AF Analysis.
Add new isexcluded(attribute_reference) function to be able to easier distinguish between Tag/Attribute errors and excluded attributes. Currently it is quite tricky to filter if an attribute is in error due to data source error or an excluded tag....
Expose backfilling/recalculation status in the AFSDK
Currently analysis runtime information can be accessed programmatically using the AFSDK (AFAnalysisService.RuntimeInformationFields - https://techsupport.osisoft.com/Documentation/PI-AF-SDK/html/P_OSIsoft_AF_Analysis_AFAnalysisService_RuntimeInfor...