As a PI SQL Client OLEDB user, I would like to have the TIME(), DATE(), LOCALDATE() and TOLOCALDATE() functions available in order to construct datetimes for my queries.
These functions were available in PI OLEDB Enterprise, but are not available in PI SQL Client OLEDB.10 votes
Please add PI TagMedian function in AF analysis like PI TagAvg and PI TagMean. Currently Median function is available but it cannot be applied for archive values of PI Tags during particular time range5 votes
Planned for 2018 R2. The Median function will support analytics array introduced with the 2018 release.
- Don't see your idea?