M
Mike Mahoney
PS 2007 generate 3 cubes to do with timesheet analysis.
TIMESHEET
EPM_TIMESHEET
MSP_PROJECT_TIMESHEET
TIMESHEET contains all the basic timesheet data, period, resource name
and project. It does not contain any additional project or resource
attributes.
EPM_TIMESHEET develops TIMESHEET (a little). It has the same basic
structure but it modifies the task list details. As a consequence all
Admin category time is removed as well as any time booked at Project
top-level (as opposed to specific task). I have also noticed instance
of specific tasks "losing" time booking in this cube. So this cube
does NOT contain a complete analysis of timesheets
MSP_PROJECT_TIMESHEET is a virtual cube which combines EPM_TIMESHEET
with RESOURCE and ASSIGNMENT Timephased cubes. Thie allows you to
slice and dice timesheet data by project and resource custom fields
and also to compare actual timesheet time with MSP actuals and
planned, EXCEPT for the missing (top level) DATA!.
Time may be booked at the top level for convenience or because a team
member does not have specific assignments or because you implement
Activity plans to collect specific support/admin effort.
So can anyone from Microsoft tell me if the EPM_TIMESHEET cube is by
design or contains a bug?
Regards
Mike
TIMESHEET
EPM_TIMESHEET
MSP_PROJECT_TIMESHEET
TIMESHEET contains all the basic timesheet data, period, resource name
and project. It does not contain any additional project or resource
attributes.
EPM_TIMESHEET develops TIMESHEET (a little). It has the same basic
structure but it modifies the task list details. As a consequence all
Admin category time is removed as well as any time booked at Project
top-level (as opposed to specific task). I have also noticed instance
of specific tasks "losing" time booking in this cube. So this cube
does NOT contain a complete analysis of timesheets
MSP_PROJECT_TIMESHEET is a virtual cube which combines EPM_TIMESHEET
with RESOURCE and ASSIGNMENT Timephased cubes. Thie allows you to
slice and dice timesheet data by project and resource custom fields
and also to compare actual timesheet time with MSP actuals and
planned, EXCEPT for the missing (top level) DATA!.
Time may be booked at the top level for convenience or because a team
member does not have specific assignments or because you implement
Activity plans to collect specific support/admin effort.
So can anyone from Microsoft tell me if the EPM_TIMESHEET cube is by
design or contains a bug?
Regards
Mike