Thanks. Very helpful video. I am trying to set up an energy monitoring system. Some of what I am trying to do is very similar to what you show. The main difference is that you are doing the integration in Pi where in my system that integration is already done at the meter level. I read a totalized energy value (KWH) and record that. So my "math" is to calculate the difference in that totalized energy value at 2 time periods. Any suggestions on getting me started with that? Thanks in advance.
Hi RK, the demo AF database I was using has links to external tables - it wouldn't work if I exported it without further meddling. The database exists in the environment described in the video description. If you don't have a subscription and want to follow along with the calculations I was showing, you could use any tag that represents an instantaneous power (or just pretend another tag you have is a tag representing a power). -Alex
Hi RK, you're in luck, I streamed on the PI Connector for OPC UA a while back: ruclips.net/video/IsqpCLtytCs/видео.html For the integrator I recommend the course playlist for the PI meets BI online course: ruclips.net/video/9Fks6szvGVg/видео.html For PI SQL Commander I recommend the course playlist for the PI SQL online course: ruclips.net/video/93h6Cra_4Mw/видео.html Both of the above courses are available to purchase on our learning website learning.osisoft.com if you need a virtual environment to go along with the videos. -Alex
Thanks. Very helpful video.
I am trying to set up an energy monitoring system. Some of what I am trying to do is very similar to what you show. The main difference is that you are doing the integration in Pi where in my system that integration is already done at the meter level. I read a totalized energy value (KWH) and record that. So my "math" is to calculate the difference in that totalized energy value at 2 time periods. Any suggestions on getting me started with that? Thanks in advance.
Hey, did you manage to do it by this method?
Please share demo AF database download link.
Hi RK, the demo AF database I was using has links to external tables - it wouldn't work if I exported it without further meddling. The database exists in the environment described in the video description.
If you don't have a subscription and want to follow along with the calculations I was showing, you could use any tag that represents an instantaneous power (or just pretend another tag you have is a tag representing a power).
-Alex
@@AVEVAPISystemLearning Thanks Alex
I am waiting for PI connector & PI Integrator, PI SQL commander related videos as well.
Hi RK, you're in luck, I streamed on the PI Connector for OPC UA a while back: ruclips.net/video/IsqpCLtytCs/видео.html
For the integrator I recommend the course playlist for the PI meets BI online course: ruclips.net/video/9Fks6szvGVg/видео.html
For PI SQL Commander I recommend the course playlist for the PI SQL online course: ruclips.net/video/93h6Cra_4Mw/видео.html
Both of the above courses are available to purchase on our learning website learning.osisoft.com if you need a virtual environment to go along with the videos.
-Alex
@@AVEVAPISystemLearning Thank you for sharing the quick reference links. Appreciate your quick support.
That is a very good explanation, it's handy but, the moment we can't add the Calculated value of an event that is very annoying!