Timesheet report with good performance.

[vj857]

Hi,
Can anyone help me in creating a performance efficient timesheet report?
I have created the employee monthly timesheet with all needed information such as: all days of selected month along with work entries, total employee vacation days, total sick leaves, total working days in a month, total hours worked, overtime(in hrs).
The report is working perfectly but my concern is performance. The report's Total Execution Time is 77395 ms. Most of the execution time being consumed by one query to calculate "total working days in a month". I have tested the report without this query and the Total Execution Time 781 ms. So the issue is with Working days query.
Is there any simple way to calculate the "total number of working days" in a month based on a user calendar? It must exclude weekends (Saturday and Sunday) and all Public holidays (including any Halfday holidays ).

I would be happy to provide more details if needed.
Thank you for your reply in advance.

[magicianer]

Do you have a calendar/date dimension in your data warehouse? It sounds like that's what you would need, one with the holidays though.