Actual Work by Day (Time) - Table sources of information

[TroyS]

I was wondering if someone could confirm some aspects about the PS2003 data model...?

1) The olap cube builds Actual Work by Day. This is shown in the MSP_Cube_Assn_Fact table. However this table does not go down to the task name/task id level. This includes Scheduled Work by Day as well.

2) The only other source of Actual Work by Day is from the MSP_Web_Work table (timesheet). However, in order to extract time by day, a loop needs to be employed as the start/finish dates provide a range of days that the actual work is recorded over. This applies to scheduled work as well.

Are there any other sources (tables or views) of information in the existing database schema to get Actual Work by Day down to Project, Resource, Task?
Any other suggested ways of going about getting Actual Work by Day down to the resource/task level?

Here are my issues:
1) Since the existing olap cube (portolio analyzer) does not show task name, i don't want to customize or extend the existing olap cube as microsoft doesn't support it. Nor does Microsoft support anything in the Project Server 2003 SDK.
2) I don't want to necessarily want to use existing cube tables as one must have to wait for the cube to rebuild itself before the data has been updated.
3) I don't want to rely on the cube tables as sometimes the cube rebuilding process fails
4) I want to grab the most up-to-date data from the database tables so that as soon as projects are updated/saved/published, the database is updated and the underlying report is up-to-date.

any insight will be appreciated....thx.

 

[rajanmisra]

Hi

If you want Actual Work and Actual Work protected you should look at
the table

MSP_VIEW_PROJ_ASSN_TP_BY_DAY.

But remember this table will have values only after resources have
submitted their time in web timesheets and the data has been updated to
the project by the project manager.

If you want to have "actuals" as soon as the resource enters his time
in the timesheet , without they being updated to the project , you have
to use the MSP_WEB_WORK table.

Thanks

Rajan