PS2007 Cubes

M

Mike

There are two cubes one called Timesheet and the other EPM Timesheet.
They appear to have the same definition. From my perspective
Timesheet contains correct timesheet data, EPM Timesheet is
deficient. Is this second one a developer's residue or does it have a
purpose?

Thanks

Mike
 
B

Ben

They are different, in that if a resource has not submitted a timesheet view
then they will not be part of the Timesheet Resource List dimension. If they
have submitted timesheets, but subsequently become inactive, their data will
still appear in the cube.
In the EPM timesheet we can work with Time as a dimension in addition to
Fiscal time.

-- Thanks, Ben.
 
M

Mike

They are different, in that if a resource has not submitted atimesheetview
then they will not be part of theTimesheetResource List dimension. If they
have submitted timesheets, but subsequently become inactive, their data will
still appear in the cube.
In theEPMtimesheetwe can work with Time as a dimension in addition to
Fiscal time.

-- Thanks, Ben.
Click to expand...

test mail
 
M

Mike

test mail- Hide quoted text -

- Show quoted text -
Click to expand...

Ben

Both cubes have time and fiscal time dimensions

The Timesheet cube includes Admin time, the EP one does not

I ran a test in a new environment with 2 projects/2 resources/5 weeks
of timesheets and progress. Initially both cubes behaved. I then
played around with "replace Actual with Planned" and "Import Task
Progress" and deleting timesheets (and recreating them). This upsets
the EPM timesheet cube it "loses" actuals" but Timesheet cube is OK.
Both cubes develop problems with planned work having values which are
different to the Main cubes (MPA/MSP Timesheet/Portfolio Analsyser).
The problem is also impacted (I think) by whether you have timesheets
pre-populated. or not.

I would be interested if anyone else can confirm these observations

regards

Mike

(Ps I have sent 3 variants on this post but google/newsgroup not happy
- apologies if this triplicates!)
 
Top