Data Cube Differences??

D

dj_mac

of I am running into confusion on Data View content.

I am using PS 2007 and when I use a data view to look at the Timesheet cube
data I get a actual worked billable hours of 296.75.

When I use the MSP_Project_Timesheet cube data I get a value of 73.5 for the
same time period.

Any idea of what is going on?

Thanks for the assistance.

Doug
 
S

Sander

I have seen the same behaviour and had some time to dig in to the scheme
description of the reporting database.
There is a difference in the Timesheet project list (in timesheet cube) and
the project list (in msp_project_timesheet cube) considering the project
name. When a project name changes, it does not change on the timesheets that
exists already. So 1 project can have different names in the timesheet
project list.
I suspect that the OLAP cube does not match correctly the differences to
have the same actual work values in both cubes.
Have no proof of this, it's just something that's on my mind for some time
now.
 
Top