Customer Support is investigating developing a library of examples for PI AF. The goal is to help you get started in PI AF or continue to expand what you do in PI AF. These examples could consist of one or more assets or element templates and the corresponding attributes and analyses.
There are a number of areas that we could focus our efforts on. What is the top topic below that would help you? Where should we put our effort?
Thanks for the comment Philipp! It seems there is definitely a need here.
Security configuration could depend a lot on your organization's needs. Do you want your end users to be able to create their own hierarchy, or just use one that's been created for them? Do you have users or groups that need some data but are restricted from viewing other data? What will be "consuming" the data (PI ProcessBook or DataLink on an engineer's computer, a company-wide dashboard, 3rd-party applications, etc.)? Could you describe your scenario?
I'd like an example on the user has the rights on creating and define the notifications.
Hi Charles,
Thank you for your suggestion. I hear a lot of feedback that people would like to learn more about AF and notification security, and I am looking into how we could demonstrate that in an example.
As a quick attempt at giving you an example, in AF v2015 R2, the notifications security can be managed on the AF Server level. There are settings specifically for the creation of notifications and for managing the contacts on the notification templates.
For some more details or specific questions, I’d recommend contacting Tech Support (https://techsupport.osisoft.com/Contact-Us/) for your questions.
Thanks,
Megan
Examples how to grammatically access EventFrames information (e.g. add Attribute-values, change eventframes...)
Hi Franz - By grammatically - do you mean using substitution parameter syntax or the AF SDK or...? What application do you want to pull the EF information into? Thanks for the additional information!
Hi Megan,
sorry for my bad comment. i did mean programmatic. i mean for example change the time of events via AF SDK. about the application i think about processbook. also coresight would be interesting, but i think it's not yet possible to code in coresight. if there third party products which already have objects connecting to AF and have an API or SDK it would also be interesting.
You may want to check out the AF SDK Reference in the help of PI System Explorer (PSE) which documents the AF object model including event frames and how to interact with them. Note, the StartTime appears to be ReadOnly.
This is not programmatic, but you can change the times of an Event Frame in PSE. You'll want tread lightly so as not to have "overlapping" event frames.
Also, PI Vision (formerly know as Coresight) has an extensibiity model to adding your own functionality. Examples can be found on github OSI-Samples-PI-System/PI-Vision-Extensibility at master · osisoft/OSI-Samples-PI-System · GitHub
Another topic would be Examples of Query Data with PI OLEDB Enterprise. If possible also to write data (e.g. change an Attribute value via OLEDB Enterprise). But it think writing Data via OLEDB Enterprise is not working.
SQL Commander Lite (installed w PIOLEDBE How to Install PI SQL Commander), has example queries. Right mouse click on any table and it has Execute Predefined Query. These are generic Selects and those that need multiple tables such as Archive include the inner joins constructs.
Note that recent SQL RTQP Engine has the best performance of our SQL back ends. SQL RTQP Live Library. Example queries can be found in SQL Commander as well under PI SQL Client.
If you need a custom application to write PI data, you should consider PI Web API or the PI AF SDK.
Finally here's a good post on choosing the right product for some use cases Solution: Selecting the Best Product
How to connect attributes to non-time series, non-PI tag data sources and cope with differences in "the shape" of that data.
Hi Neil - What non-PI tag data sources would you like to pull data from? What is "the shape" of that data (relational, etc)? Thanks for the additional information!
Thanks for your reply.
Actually that is the crux of my request. There will be limitation of data mapping based on the "shape". You could have a file data source that is reading information exported from Excel as a CSV file. You could even have something like a web service reading current temperature and rainfall values. So it would be nice to have a small case study of how to map data from these foreign data sources onto PI tags and making them visible in the PI AF elements.
We use Notifications often, I would like to "Search", with out having to subscribe to emails, and be able to create new Notifications in PI Builder for Excel
Please provide a example kit for RBI (Risk based inspection) so that we could utilize it for various Industries.
Hi Balamurugan,
Thanks for the great suggestion! We’ll look into a kit based on risk based inspection and see what could be done.
Thanks,
Megan
Would some of the same principles for CBM apply to RBI? If so, check out these kits Pump Condition Based Maintenance Toolkit (AF Asset Based PI Example Kit) Asset Based PI Example Kit for CBM for Small Hydropower Plants Asset Based PI Example Kit for Condition Monitoring
I'm looking for examples using Ports, Models and Transfers
Hi Robert,
Unfortunately, we have no plans to create AF examples with ports, models, and transfers. These are actually legacy features from PI AF 1.x and are still available for those using PI AF 1.x and Sigmafine products. None of our current client tools support them. You can find and publish them with the PI Builder Excel add-in, but that's about it. I'm sorry! Please let me know if you have any other questions about it.
Cheers,
Megan
I am looking for examples where the assets differ between facilities. As soon as I get above atomic assets (pumps, motors, valves, etc.) I run into differences between and within facilities. How do I use templates (base + inherited) to isolate facility dependencies. Use cases include 1) Some PI tags are missing and must be synthesized... Where in the AF hierarchy do I put the differences? 2) Facility is doing specialized calculations that need to be included with the asset...
I want to capture information into event frames and visualize with PI Vision.
I´m looking for examples in catalyst deactivation, particularly in FCC, CCR and HDR units, ¿do you have something like that?. Thank You.
I'm looking for examples on how to use AF to calculate the performance of Control Loops (How many time they stayed in Manual/Auto mode).
This would be excellent! It's actually on my list of things to do in my spare time...so you know what that means :-/ Our site used PI's Control Monitor, and migrated to rCAAM as soon as it became available (we were one of their beta sites, but sadly, there wasn't enough other interested parties to keep the product alive). INTUNE and PlantESP are expensive options - AF is free'ish (will take lots of tags, though). It won't be as flexible as an application, but it will get the job done! For controller mode, you could calculate TimeEq to 'auto' and count mode changes. You can also count Set Point changes, calculate 2sigma for your Process Variable, totalize your valve activity for 'travel', PV deviation from SP, etc., etc., and AF would quickly even build the Metrix tags for you (a lot of tags it could be). I think this would actually be very easy, AND very valuable...if you have time. Does anyone have time? (be forewarned - building this will be the easy part - populating it afterward with all your loops will be the hard part) PS, the template is no good without a display or spreadsheet to prioritize the bad actors.
I'm looking for sample PI AF Kit for Life Science.
There are some more generic samples on the page here: Asset Based PI Example Kits
Any specific functionality you are looking for in a Life Sciences kit?
In regards to event frame triggers, an item that seems to come up regularly is: being able to trigger event frames for a single tag changing state.
For example, a 'device' changes states from stopped to starting to running to paused to faulted. Each change should trigger the current event frame to end and a new event frame to start; this CAN be done, but it isn't intuitively obvious how to do so.
Also, don't assume everyone is using the latest version of AF and Asset Analytics; provides examples for multiple versions of AF and AA, possibly the last 3 major releases.
イベントフレームは利用用途が広そうであるが、構文が難しいため、利用するにはハードルが高い。
したがいまして、レシピ集があれば応用が利くため、数多くの事例をサポートしていただきたい。
I am interested to see more for Azure and AWS related best practices while AF and PI deployment for Mega AF and PI server. Interested to see storage, compute and networking practices with SQL always on, load balancing related best practices also.
I would like to see examples to convert pialarm tags and pi totalizer tags to equivalent AF Analysis rules. May be the pitot sample tags (totalizerpts.dif) would be a good start. By default alarm and totalizer are no longer installed with pi data archive version 2018, so i understand it's a deprecated feature.
I would suggest some of the newer features in AF.
Such as the Event Frame Generation Mode options for Event Frame Generation Analyses. These are not well detailed in the Live Library yet.
PI Interface Health Monitor - I think I may have something that is satisfactory. How do I submit it as an Asset Based PI Example Kit?
Not a direct answer, but check out that there's an asset health kit that includes interfaces at a high level IT Asset Monitor Toolkit
Fix the download links to the asset based example kits.
Give examples of security configuration (e.g. should security be set on the database, on templates, on elements, or a combination of them.. etc.)