Data Analysis View

[Daisy]

Hi,
I want to create one View that show me the Schedule Variance, means it
should be the difference of Actual End Date(date when the task is actually
finished)-Estimated End Date(date when the task is supposed to be
finished).But there is no date type field available in any of the cubes.How
can I do this.Please help

 

[Stephen Sanderlin]

I would create a task-level custom number field with the formula
IIf([Actual Finish]=ProjDateValue("NA"),0,([Actual Finish]-Finish)). I
would set it to roll-down, and roll-up as SUM. Note that tasks that are
incomplete as well as tasks with no variance will both show as 0, so you
should probably filter out tasks with % Complete < 100 or Remaining Work

0.

Then, add this to the desired cube. Note that if you don't need to do
any manipulation of the data in the view, you may want to consider not
adding the field to a cube and creating the view as a regular Project
view.



Does this help?


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com