• State Not Answered
  • Replies 1 reply
  • Subscribers 3 subscribers
  • Views 170 views
  • Users 0 members are here
Options
Related

Sub-selection for Events in PI Vision

ABrown

Hello,

 

I am trying to select a dynamic specific group of Events using the Events option in PI Vision.

Let me start by giving a break down of what our Asset Framework looks like and what group of events I am attempting to grab.

AF structure:

Server

->Database

----->Team 1

---------->Substation 1

--------------->Breakers

-------------------->Breaker 1

-------------------->Breaker 2

-------------------->Breaker 3

---------->Substation 2

--------------->Breakers

-------------------->Breaker 1

-------------------->Breaker 2

----->Team 2

 

The Breakers are all setup using the same template and on that template there is an Analyses that does an Event Frame Generation to check the status of the breaker and if it is in a Open status then start an event and once the status is closed then end the event. A pretty straight forward:

Start trigger: if TagVal('Status', '*') = "OPEN" and PrevVal('Status', '*') = "CLOSED" then true else false

End trigger: if TagVal('Status', '*') = "CLOSED" and PrevVal('Status', '*') = "OPEN" then true else false

This is working as expected and giving the results for an event as desired.

Now to where the challenge is, team 1 has asked to have a PI Vision screen setup to display all the breaker events for the last week broken out by the substation as the selectable asset.

The only items that will be on the screen are going to be the Substation Name asset and the Events Table with the above criteria. However, I'm struggling to figure out how the Search Criteria can be setup to accomplish what the team is asking.

In looking through the Edit Search Criteria:

I can select the Database correct database.

I can also set the Time Range to Custom Time Range of Start: *-7d and End: * to get the correct data source and requested time range.

The Event Severity doesn't matter as I just want to know when there was an event.

The Event Name doesn't seem useful in this situation as I don't want a specific event and wildcarding causes multiple breakers not under the selected substation to also be selected.

The Event Type under the Event Type and Attribute Value can be selected but that returns all events with that event type which I don't want as I only want those events under the specific substation. I could add an Event Attribute to the search but then I have to hardcode the attribute value I want selected which then doesn't allow for dynamically selecting the value for the substation.

Under the Asset Name I have attempted to use the Assets on Display option with the Substation Name asset added to the screen, however, this doesn't work as the Substation doesn't have any events but rather the breaker sub-assets do. I've tried this option with both the Return All Descendants option checked and unchecked and got the same results for both which was no results and there should be results for all the sub-asset breakers. I know there is the option to Specify Name but from what I have found while testing even though it allows for wildcards such as * (multiple character) and ? (single character) the results aren't always correct if any results are even returned. I've also tried using the AF substitution parameters in this box but those don't seem to work so this option seems to not be a possibility.

Under the Asset Type I could select the asset type that has been set but much like the Event Type then I get all assets with that asset type returned which isn't desired.

Event state doesn't matter as I want all the events returned in the week time period.

Event Category isn't helpful as it has a similar issue to that of Event Type and Asset Type.

Event Acknowledgment doesn't help as I want all events returned in the week time period if they are acknowledged or not.

Event duration doesn't matter as I want all the events returned in the week time period.

Search Mode is set to Events Active in Time Range as I want all the events returned in the week time period whether they started, ended, or began within that time period.

 

I'd appreciate if anyone has run into a similar situation or has some insight that they could provide.

 

Thank you,

Alex

  • 0

    Hi,

    This will be rather tricky and depends on your PI Vision version. In a recent version, you can specify to use the Asset: filter as "root". If you can select the substation using this filter, and specify to use it as root, it would seem that breakers that are children to the substation will then be included and should pick up the EF's.

    Obviously, you can use the search criteria and have users add in the search criteria for the substation in a few different ways, including a portion of the name, or an attribute, etc.

    If you include the substation as an attribute of the EF, then add that attribute to the EF table, users should be able to sort and filter the table by the substation. These are both not exactly what you're looking for, but may help.

    You may also have to consider using the sub as the referenced asset, but that is tricky too. You may consider adding a metric to the substation to indicate if any breakers are open or not, then users would drill into only those subs with open breakers, then see the EF list.

    Thanks,

    Keith