more quick actions
minimize quick actions
Alarm Data mgt
11
Posts
4
Users
0
Likes
47
Views
Is it possible to do Alarm Documentation and Rationalization through PcVue?
Posted : 21/11/2017 8:55 pm
Hi,
I think you must be a bit more specific.
What do you mean exactly by "Documentation and Rationalization"?
Nico
Posted : 22/11/2017 8:57 am
Please find the attachment for the details.
Posted : 22/11/2017 11:12 am
According what I read I could say:
- Documentation: Yes. It is just recording the alarms and give the possibility to request them...
- Rationalization: No. Apparently there is specific software for that (from Exida here)
Nico
Posted : 22/11/2017 11:20 am
I have attached a document, they need these in the KPI screen. Is it possible without a 3rd party software?
Posted : 22/11/2017 11:53 am
Yes it is possible. 2 ways actually:
1. Use data export and then Excel to analyze
2. Store the alarms in SQL Server and then use SQL Server Analysis services, Power BI or reporting Services
Nico
Posted : 23/11/2017 7:38 am
Do we have Active X for the above or any other method is there to integrate with PcVue?
Posted : 23/11/2017 11:05 am
No I am afraid we don't have.
Nico
Posted : 23/11/2017 12:17 pm
What will be the solution to display in PcVue?
Posted : 23/11/2017 12:29 pm
Reporting Services web portal can be displayed in WebBrowser ActiveX inside PcVue.
That is what is done in the current demonstration project in the demo virtual machine.
Posted : 23/11/2017 3:29 pm
May not appear straightforward, but not deadly complex neither.
If archiving alarms with the HDS, most of these KPI can be calculated thanks to SQL requests (or stored procedures). Various strategies here, I am not going to elaborate more.
Then for display, it depends first on 'where' you want to display. Many potential solutions:
- From the simplest: Power BI outside PcVue or SQL Server Reporting Services
- To the most integrated in mimics: Use the Chart control with a bit of scripting for inserting data. But requires to get the values from the SQL request. There, it depends on how you need/can achieve it (VBA scripting to execute requests, DbConnect in v12...).
Going with Data Export can be a solution if not using HDS for archiving, but calculating the KPI in Excel may be tricky.
These requirements have been lurking around for a while now, your post and answers raised an idea.
Do you think adding such KPI as new stats in the Data Export would make it clear and easy to set up ?
Regards
Posted : 19/12/2017 11:53 am