Individual record for Absence Data for Employees

Summary

Using OTBI subject Areas to fetch absence details

Content

Hello All,

I need to create an analysis where I am reporting on Direct Reports who have absences. What different I need here is I need single row details for all the absences an employee takes.

For example, if Employee A takes an absence from1/1/19 to 1/5/19, I need 5 rows for this employee. Similarly if an employee takes an absence from 1/1/19 to 1/9/2019, I need to get 7 (assuming 1/1 is a Monday and I am excluding Weekends) records for this person on my analysis.

Is there any subject area which has single entries even for a Date Range of absences applied by an employee?