May 19, 2008 at 12:07 pm
How can i design tables so that I can get the hours worked for each day row by row and exclude the time the person went out for breaks, Just need to aggregate the hours he worked for a day and each day should come in row.
I am trying to design a cube for this .
May 19, 2008 at 1:11 pm
If you have a measure that is the number of minutes, the sum of this measure by date (assuming you have a date dimension) should be the number of hours worked. Each fact should have a date, a start time, an end time, and a number of minutes (just the difference between the two times) and then just insert time worked.
Here is a tip - structure your ETL process to cut work into two pieces if it spans more than one day.
May 20, 2008 at 2:59 pm
If the lowest level of granularity is per day I would suggest incorporating this logic to aggregate the hours by day into your ETL process. No need to store the minute by minute activity if it's not needed...
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply