I am trying to understand the dataflow.
1. How does Process Book interact with AF?
2. What is stored in AF SQL DB?
1) ProcessBook interacts with AF using the AF SDK.
2) AF stores everything in the SQL DB. AF takes calls from the AF SDK and determines which instructions to run on the SQL Server.
Thank you Paul.
By everything do you mean point data too? For instance the latest data from
The point of process data with AF is that the graphical display has actual
names instead of .PV names right? Or is it something more?
To be clear, everything about your AF Hierarchy is stored in SQL.
The instrument data is stored in the PI Data Archive. When you request a data point, AF will route that call and return the result to you.
AF has many uses, one of which is presenting tags in a friendlier manner.
One of my OSIsoft colleagues compiled a list last year that has a bunch of resources showing the benefits of using AF:
Business benefit of using PI AF?
Everything is such an all-encompassing word. So everything except PIPoint definitions and PIPoint data. Anything with your hierarchy: templates, categories, local AFTables, general header info for linked AFTables, elements, attributes, hierarchical structure, analyses, event frames, and UOM database.
For event frames with any attribute using a data reference, if the event frame that called CaptureValues then even the PIPoint data will be captured for the time range and saved in SQL Server for that event frame. Imagine if you were performing a summary for a PIPoint over the event frames time range, it would be a performance hit to query it each time you needed it, particular for a lot of data over a long time range. So you may capture the summary once, and save that one value in SQL Server. Which means that even some times, PIPoint data is stored in SQL Server.
Which really is almost everthing.
I'm still unclear about the role of AF with processbook. All videos and
tutorials show AF with coresight. Can you explain the role pls?
Within ProcessBook specifically, there are a number of nice features you can take advantage of. They are designed to speed up creation of displays and also to make the displays easier to read.
Here is a nice video that showcases some of these features: OSIsoft: Quickly Create Displays with the PI ProcessBook AF Display Builder or Data Favorites [v3.5] - YouTube
Retrieving data ...