Periodic trigger monthly and yearly
I would like to have monthly and yearly periodic trigger for Analysis-Expression and Event Frame Generation. Currently I have to use the daily trigger and check in the analysis if the month or the year changed. In case of “false” there is no output. In the case of “true” there is an output. This works but it is circuitous.
Christoph Rose commented
yes it is somewhat of a convoluted workaround and limited to a certain extent (as you mentioned combining day and month does not work). I mostly posted it because it is a solution that doesn't require setting up separate PI Points and Analyses as triggers.
I am also surprised that the day and month triggers are actually shown in the System Explorer correctly. So there was apparently some work done to support this already. All that is missing is UI elements within PI System Explorer that enable editting directly (instead of using PI Builder).
ChristophRose, good to know, thanks.
I'm impressed that the configuration used in this way DOES show up in PI System Explorer . . . but its not a complete solution for this feedback item if it can only be completed through PIBuilder, especially when this method is not even described anywhere in the documentation.
I would also argue that this method is just short of what is actually needed. In my opinion the need for Monthly analysis is going be more commonly based on day of month or first business day of the month.
It also looks like you cannot combine Day and Month using the method below. It looks like it will follow the Month and ignore the Day configuration.
Christoph Rose commented
This is already possible.
To do this, first create the Analysis in the System Explorer and set the trigger for daily.
Then load the Analysis in PI Builder (Excel). You can then edit and publish the analysis from there.
The Column "TimeRuleConfig" will be set to:
Day=Sun, Mon, Tue, Wed, Thu, Fri, Sat
To execute every Monday at 00:00, set the TimeRuleConfig to:
To trigger monthly, set the TimeRuleConfig to:
Month=Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec
To trigger yearly, set the TimeRuleConfig to:
Of course you can also set the trigger to something like:
Month=Jan, Apr, Jul, Oct
You can add an offset of up to one day by adding a Offset=XXXX (in seconds, separated by a semicolon).
I haven't (yet?) found a way to trigger on a certain day of a month.
This current suggestion is NOT the same as meierke1 reference.
meierke1 references this being the same request as another. The other one reads differently to me. The other one was also completed in Server 2018. I see nothing in the release notes concerning the ability to schedule analysis weekly or monthly . . . so it does not appear completed yet.
We have not moved to Server 2018 quite yet . . . so someone can correct me if i'm wrong about whats in the release notes.
Kevin Meier commented
i guess this is the same request https://feedback.osisoft.com/forums/555148-pi-server/suggestions/17888542-easily-create-periodic-event-frames
Keilan Knight commented
I have created helper timestamp tags which only write a value every month and every year (etc.), these are in a top level element so any calculations I need triggered monthly or annually simply have those attributes added as full path in the analysis, and that is set as the trigger source. This can be done with a couple of mouse clicks alone so is fairly trivial. The only problem is when there is an archive overlap, the "arc off-line" errors can provide false triggers, best disabling "mark archive gaps".
But yes, getting this functionality built in would make life a lot easier. User defined schedules would help (like shifts)
'weekly' would be another somewhat common period for KPI type analyses in AF