Get Project Indicators by Status Date

[Mask]

Hello,


I'm working in MOPS 2007 with SQL 2005. I'm developing some Reports in
Reporting Services.

I made 1 EVM Project view and I would like to build 1 report that
could show the Project Status report according to Status Date.

Example: My Project have 1 month duration. People report hours in EPM
timesheet every Friday. I have defined Sundays as my Status Dates. So
in 1 month I have 4 Periods. I wanted my report to show how Project
was in those 4 different periods, getting the values of CPI, SPI,
BCWP, ..., according to the 4 Status Dates.

Question is: How can I get the diferent values from my indicators if
my BD only keep the Project Status Date I had published im MO Project?
How can I get the values from other Status Date?


Thx in advance,

Mask

 

[Ray McCoppin]

Project Server does not capute thing like indicators overtime (timepahsed).
I have done this by creating new custom tables to store the data and SQL
batch job that snapshots the data a time (your status dates).

Hope this helps.
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 Mass Resource Tool

Project Server 2007