cancel
Showing results for 
Search instead for 
Did you mean: 

Starting day of a week Changes

AnuBharathi
7 - Data Storage
7 - Data Storage

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

1 REPLY 1

Silutions
10 - ETL
10 - ETL

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

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!