PS2007 - Actual work billable hours missing in 2 of 3 timesheet cu

[Barbara - Austria]

Hi,

I need to create a data analysis view that provides actual work billable
based on customized enterprise fields on task and on project level.
These fields are only available in the virtual cube MSP_Project_Timesheet.
Unfortunately in this cube there are 0 hours, even without adding any
dimensions to the view. Since I have read in "Implementing and Administering
Microsoft Office Project Server 2007" that this cube is based on EPM
Timesheet, I have also checked that one. There are also 0 hours for Actual
work billable in there. EPM Timesheet in Analysis Server is referring to
MSP_TimesheetActual_OlapView. In that view actual billable work is shown
correctly. So I think something doesn’t work with building these 2 cubes.
There are no errors when building the cube. Has anyone experienced something
similar?
Moreover the hours are also shown in cube “Timesheetâ€. Unfortunately in that
one I am missing the customized fields …
SP1 is applied, so is hotfix rollup SP1 since an issue with
MSP_Project_Timesheet was mentioned. It didn’t help.

Any ideas are appreciated!

Regards
Barbara

 

[Mike Mahoney]

Hi,

I need to create a data analysis view that provides actual work billable
based on customized enterprise fields on task and on project level.
These fields are only available in the virtual cube MSP_Project_Timesheet.
Unfortunately in this cube there are 0 hours, even without adding any
dimensions to the view. Since I have read in "Implementing and Administering
Microsoft Office Project Server 2007" that this cube is based on EPM
Timesheet, I have also checked that one. There are also 0 hours for Actual
work billable in there. EPM Timesheet in Analysis Server is referring to
MSP_TimesheetActual_OlapView. In that view actual billable work is shown
correctly. So I think something doesn't work with building these 2 cubes.
There are no errors when building the cube. Has anyone experienced something
similar?
Moreover the hours are also shown in cube "Timesheet". Unfortunately in that
one I am missing the customized fields ...
SP1 is applied, so is hotfix rollup SP1 since an issue with
MSP_Project_Timesheet was mentioned. It didn't help.

Any ideas are appreciated!

Regards
Barbara

Barbara

The cube does not do what it claims to do (applying project and task
dimensions against actual billable hours). You will need to develop a
custom cube.

regards

Mike

 

[Barbara - Austria]

Mike,

I was afraid of that answer ...

What had been corrected by post-SP1 hot fix package (KB 941426) regarding
MSP_Project_ Timesheet cube???

However, we will find another way to get requested data.

Thanks a lot!
Barbara