Accumulating Time - Professional Services Firm
2 posters
Page 1 of 1
Accumulating Time - Professional Services Firm
Good Day,
I am trying to create a model to represent time in a professional services firm. Time moves from work-in-progress (WIP) to a pre-bill and finally to a bill. I want to be able to review the age of the WIP. I am leaning towards the accumulating snapshot. I am envisioning 3 rows per time entry considering that time has 3 states with the relevant role playing dates. There is the other thought to have a more horizontal structure where I have a lag for each state. This is a hard concept for me to grasp. Thoughts anyone?
I am trying to create a model to represent time in a professional services firm. Time moves from work-in-progress (WIP) to a pre-bill and finally to a bill. I want to be able to review the age of the WIP. I am leaning towards the accumulating snapshot. I am envisioning 3 rows per time entry considering that time has 3 states with the relevant role playing dates. There is the other thought to have a more horizontal structure where I have a lag for each state. This is a hard concept for me to grasp. Thoughts anyone?
Sofer17- Posts : 10
Join date : 2012-08-28
Re: Accumulating Time - Professional Services Firm
You only need one row with three dates. Add lag metrics as needed or calculate on the fly.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Accumulating Time - Professional Services Firm
Sounds like a plan. Thanks
Sofer17- Posts : 10
Join date : 2012-08-28

» Point of time information from accumulating snapshot.
» Time in fact or dimension? Accumulating snapshot
» Type 2 Dimension with accumulating snapshot with time stamp
» Modeling tool with support for hierarchies
» Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
» Time in fact or dimension? Accumulating snapshot
» Type 2 Dimension with accumulating snapshot with time stamp
» Modeling tool with support for hierarchies
» Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum