BCWS from pds

[jbigroups]

Hello,

We are using Microsoft Reporter to publish a monthly ev report.
Project server is our source for the BCWS and we get the ACWP from our
accounting system.

Issue: the BCWS is based on the status date selected for each
schedule. To synchronize planned vs. actuals we need all of the status
dates to be the last day of the month to match our accounting.

Question: Is there a way to pull the BCWS value based on X status
date, and let the script define X? If so how?

thanks,

jb

 

[Ed Morrison]

jb,

The budgeted cost of work scheduled (BCWS) will always return the cumulative
timephased baseline costs up to the status date or today's date. You could
use the Portfolio Analyzer (or go straight to the OLAP cubes). Baseline
Cost, the underlying data in BCWS, can be timephased by project and
resource. Therefore you can get the equivalent of BCWS for any period of
time you like down to the day. If you need task level info, you'll have to
extend the cube.

Hope this helps.