Summary calculations over event frame range
As a consumer of event frame data, I would like to perform a summary calculation over the duration of an event frame when an event frame closes. The output should be stored where it can be trended and analyzed.
Note: This was previously Enhancement 109090.
This is in PI Server 2017 R2, available now on https://techsupport.osisoft.com/
Thomas Bernier commented
You can check this workaround :
Elena Rakovska commented
Another use case I have heard multiple times is Rollup calculation over child event frames. I believe this might be part of this request. Many time customers need to optimize waiting time between certain steps in their batch process. Or if they have multiple "loading" phases in the batch, they would like to have have an attribute on the Batch level (parent EF) with total duration of all loading phases (sum of duration of certain Child EF). Similar for Startups etc. Currently I have seen workaround using OLEDB Ent to write such a query and then bring this back as table lookup. IT will be great if pimplier way would exist.
The request contains just a few sentences, but if i think what i could build with this...
I think this would be a valuable ans relatively easy extension to EventFrames. Now doing analysis on EventFrames (like How much downtime, average batch duration, etc.) are difficult to achieve. When we can output data from an EF to a PI Point (e.g. at the moment of value capture), then we could string together a lot more business logic!
Calman Drysdale commented
being able to use start time and end time as variables which run in a formula or analysis on the ending of the event frame would be amazing.
Pierre-Henry Henry Tincelin commented
It would be nice also to have the ability in the analysis managing 'start trigger' and 'end trigger' to add variables and expression calculations mapped to an attribute/PI tag. This attribute should be attached to the generated event frame (but the PI tag unique. I mean not a different PI tag for each event frame generated ...).