T
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.
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.