I don't even know if I can explain this adequately, but I will make an
attemp at it...

One of our cubes is based on our time entry system and we need to be able to
calculate utlization for our billable personnel.

Utilization is defined as:

(Non-Administrative Time) / (Total Available Time)

where non-administrative time is all time that is posted to either a
billable or non-billable task and total available time is the total time for
the day (8 per day * 5 days per week = 40, 4 per day * 5 days per week = 20,
etc).

Our fact table grain is at the task level.. For any given person, we can
naturally pull total hours worked for a given day (semi-additive). What we
can't do presently is determine how many hours they SHOULD work for the day.
One would assume 8 but we also have part-timers. What are some possible
solutions we could use to create the denomimator in such a way as to allow
utilization to roll up from a lowest view of {Person * Date}to the highest
view of { All persons * All Time }?

Thanks

Tim