Forum Discussion

AnuBharathi's avatar
AnuBharathi
Data Storage
05-02-2022

Starting day of a week Changes

Hi All,

I'm trying to change the starting day of the Week in Cube level, Need to calculate Total Hours worked by an employee from Saturday to Friday. If I choose Week range(week 1, week 2, etc..) then my week selection should calculate total hours from Saturday to friday. It would be great if anyone could help me in finding the solution

Thanks in Advance,

Anu

dashboards & reporting

1 Reply

Replies have been turned off for this discussion
  • Silutions's avatar
    Silutions
    ETL
    05-17-2022

    Anu,

    My solution to this in the past was to create a Custom Column in the EC that relied on Fiscal Year Start Date day of the week and then used CASE logic to calculate the week based on the start day of the week.  The new column values were Week 1, Week 2, etc.  Although they could have been anything desired.  The assumption was that any days starting the new Fiscal Year that were before the Payroll week start day were week 52 of the previous Fiscal Year.  

    So if i sum the hours worked and filter by "Week 1", I know the hours worked that period.

    Hope this helps, Jim