Currently, interpolation is a function that allows users to estimate values from 1 column to another. However, in industry, it is very possible to have to interpolate across multiple columns. Having the option is cleaner an more accura...
In AF, right clicking an attribute reveals an options called "change display UOM", but it's not doing what is expected.
To change the displayed UOMs (if, for instance, we want to see "km/h" instead of "m/h" in PI Vision), we need to do the follow...
PI AF Linked Tables used for Time-Series Data with OOO events
As AF Table Lookup Data Reference is configured with a time column in order to support cashing, edits of the following types to the table data will not be picked up by AF Clients:
1- Update the value of an Existing record/Event
2- Add a ne...
Improve "Force Creating SQL Database before PI AF Install"
When doing a fresh installation of AF Server, and either the "Validate SQL Connection" option or other Software like PI Notifications, RTQP Engine are selected, the installation cannot be started when the AF SQL Database is not called "PIFD".
As t...
Enable PI Point value retrieval methods for Digital PI Points.
We have found great use for the PI Point Value Retrieval Methods available for PI Point attributes. One such use is for displaying downtime percentage for numerous assets on a PI Vision page. The downtime percentage can be calculated for any inter...
In the PI Asset Framework Database SQL Scripts, replace the batch (.bat) scripts with PowerShell (.ps1) scripts
In the PI Asset Framework Database SQL Scripts, there are 3 "GO.BAT" files and 1 "afbackup.bat" file. These should be replaced with PowerShell scripts for several reasons: PowerShell is easier to read and is a more powerful language than the batch...
When shrinking the tabs in the lower left pane of PI System Explorer (Elements, etc.), the tabs do not shrink if shrinking by one.
When shrinking the tabs in the lower left pane of PI System Explorer (Elements, Event Frames, Library, etc.), the tabs do not shrink if shrinking by one. If shrinking by two, it only shrinks by 1, etc. These tabs should shrink accordingly.
In a string builder DR, allow use of substituted values from non PI point DRs to retrieve an attribute value
If I have two AF databases, I would like to pull the value of an attribute from one database to another. The string builder path for the other database's attribute requires a value substitution from a non PI point DR from in the target AF DB (whic...
Fix alignment of dotted border on selected attributes
When you select an attribute, a dotted border appears around the attribute. However, it is 1 pixel too far to the right. Please align it with the solid border.
Rename "Query Date" to "Query Time" in PI System Explorer
"Query Time" is more accurate than "Query Date". A time is an instant in a continuous time dimension. A date is either a 1-day midnight-to-midnight span in a continuous time dimension, or it is a single date in a discrete date dimension.
