Hi All,
I have a couple of queries around reporting on Working/Business Day calendars and Work Patterns in OTBI.
My questions are;
- Can we create custom Working/Business Days calendars in HCM Cloud that exclude Weekends and Public Holidays, and if so, can we enable them for reporting in OTBI?
- Can we report on an employee's Work Pattern in OTBI? i.e. an employee is assigned to a Work Pattern that is Monday, Tuesday, Friday.
What is the requirement?
My client has a requirement to report the Absence Leave Duration based on a date range defined in a set of Date From/To dashboard prompts. They need to report the Actual Leave Duration within that defined period and it must reflect Working/Business Days, excluding any Weekends and UK Public Holidays.
The standard Leave Duration measure in the "Workforce Management - Absence Real Time" subject area does not reflect the range defined in the prompts, it instead shows entire the duration against the absence record in the system, i.e. If the Absence End Date is greater than the date selected in the Date To prompt, the Leave Duration will calculate against the whole absence record up to the Absence End Date. We need to it show the Actual Leave Duration incurred within that period.
Can anyone share anyone wisdom?
Thanks,
Richard