Timephase Earned Value Data?

[Guest]

Hello Everyone,

I spent several hours looking through the Project Server
2007 SDK and have not found an obvious way to extract
timephased earned value data.

Before I go off the deep end and get creative, I thought it
might be prudent to ask the question here.

How can I extract timephased earned value information
(BCWS, BCWP, ACWP) at the task level using the PSI
interface?

Bob

 

[Jim Corbin [MSFT]]

See Resource.ReadResourceAssignments Method (
http://msdn2.microsoft.com/en-us/library/websvcresource.resource.readresourceassignments.aspx )
, which returns a ResourceAssignmentDataSet (see
http://msdn2.microsoft.com/en-us/li...tdataset.resourceassignmentrow.assn_bcwp.aspx )
.. I haven't tried this, but think the BCWS and BCWP data is correct after
reported work is approved.

For baseline data, you need to use the Reporting database. See
dbo.MSP_EpmTaskBaseline, dbo.MSP_EpmProject, and dbo.MSP_EpmTask_UserView.

--Jim

 

[Jim Corbin [MSFT]]

For the task level, what I meant was, use Project.ReadProjectEntities Method
(
http://msdn2.microsoft.com/en-us/library/websvcproject.project.readprojectentities.aspx )
to get, for example, ProjectDataSet.TaskRow.TASK_ACWP (
http://msdn2.microsoft.com/en-us/library/websvcproject.projectdataset.taskrow.task_acwp.aspx )
..

 

[Guest]

Hello Jim,

Thank you for your response.

I have spent a lot of time working on this during the past several
days. The key challange here is the timephased element.

I was able to extract the timephased data required from the
reporting database at the assignment level on a day to day basis.
This will become the basic fact table in my earned value management
cube.

The next big hurdle is figuring out how to calculate a total-to-date
measure using MDX in a SSAS cube. So far this has made extracting
the data look easy...

Bob