Skip to main content

Get help for ARIS Process Mining functions and services

Use the 'Union' and 'Intersect' operators to combine calendars

You can use work time calendars in work-time-related calculations or you can combine work time calendars with each other or with the results of combined calendars.

Two operators are available to combine calendars:

Intersect

INTERSECT_CALENDAR(calendar1, calendar2)

The INTERSECT_CALENDAR operator creates a calendar by forming an intersection from two calendars that specify different work time intervals.

Example 127.

You can use the INTERSECT_CALENDAR operator to intersect a weekday calendar that defines the usual work time intervals on weekdays, from 8 -17 o'clock, and a work day calendar, which excludes public holidays from this calendar. If you only used the weekday calendar, the public holidays would also be work time. If you only used the workday calendar, every working day from 0-24 o'clock would be work time. By combining both calendars using the INTERSECT_CALENDAR operator, you only have work time on work days from 8 -17 o'clock. that are NOT public holidays.



Union

UNION_CALENDAR(calendar1, calendar2)

The UNION_CALENDAR operator merges two calendars into a new calendar that contains all work time intervals that exist in at least one of the calendars.

Example 128.

You can use the UNION_CALENDAR operator for the union of a week day calendar that defines the usual work time intervals on weekdays and a factory calendar that defines additional unregular work time intervals on weekends.