Hi all, how can I exclude specific dates like bridge days from a throughput time calculation?
I am already using REMAP_TIMESTAMPS with calendar specification, but INTERSECT only accepts two arguments and they are already used for factory calendar TFACS and WEEKDAY_CALENDAR.
Ideally, I would be able to give INTERSECT a third argument to exclude certain dates and times, but that does not work.
Any other ideas or alternatives?
HI Irfan,
Wouldn't it be possible to use a nested intersect statement. As the output of intersect is also a calendar type. So you would have something like:
INTERSECT(TFACS, INTERSECT(WEEKDAY_CALENDAR, CALENDAR))
It's not really excluding, though it might be an answer to your issue.
Hi Maurits, thanks for the idea. I didn't know that INTERSECT can be nested. On the other hand, the supported calendars of INTERSECT do not allow me to specify individual dates. I would need to create a helper table where the dates to be excluded is not listed.
Anyway, I solve it now by creating a custom TFACS view for my specific use case which the customer accepted as a solution.
Thanks!
Irfan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
