@Andrew: I would start by saying there are several ways to show PI data on graphics but this will be largely influenced by what you are trying to accomplish.
Could you tell more about your use case? Is it only showing a static report produced every day at midnight? Do the concerned people need to navigate the report and drill down to more details? Are the users all employees or you get external consultants?
Roughly, I can think of some solutions like:
- Microsoft SQL Server SSRS and the use of PI OLEDB Enterprise provider
- PI Active View exposing PI ProcessBook displays filled with graphics
- PI Coresight
- Sharepoint / Excel Services and PI Web Parts
Could you define more how your PI Pages are defined?
Thanks for the response.
Currently, these are PI Displays with graphs on them: A mix of column and line graphs. We have a number of different uses for them, but in general, they are for internal use only, and the frequency of use is highly variable, but generally we would want them to be able to be generated dynamically using the most recent data. We do have one of these displays that we want to have "drill-down" capabilities, but it is fairly limited - we have a bar chart that has daily totals, and clicking on one of the bars updates a second chart showing hourly values.
The reason we like the web components is that my team (non-core-IT) can create their own displays without too much problem - VBA is well known, and new reports / charts / displays can be generated fairly quickly and easily, without (for example) having the added layer of interface of having to go via our IT department to get access & authorisation for creating new pages on our intranet. It also doesn't require that we know ASP or HTML programming, and the PI data is quite straight-forward to retrieve from within the PI application VBA environment - I haven't used PI Web Parts or Web Services, so I don't know how easy it is to retrieve data via that route.
I guess the reliable method is to hand this off to our IT department, but the problem is that they are not resourced to cope with the migration of our existing charts and displays, and it will prevent users making their own displays (unless they revert to Excel, of course).
My recommendation is to focus on products first that do not require any specific development but can be used out of the box.
Have you checked if PI Coresight fulfills your requirements?
PI WebParts and PI DataLink for Excel Services are Microsoft SharePoint based solutions. Displays (SVG) created with PI ProcessBook can be used with PI WebParts (PI Graphics WebPart).