URGENT++++!!!!Data different in cube and MS project

H

hinesa

Is there ever any circumstance under which the data in the project would not
be the same as what you see in the cube? What can I check about this project?
The project has been published and the cube has been re-built.
 
B

Bill Busby

If working in Project Server 2007 I can't help you.

If you're using Project Server 2003 the answer is YES there are times you
may see discrepancies in the published project plan and the OLAP cube.
Shouldn't be but there are. Most of the time, in my experience, it is driven
by issues in the project plan that cause the inconsistences. Potential issues
are

- Assigning resources to summary tasks. The summary task data is not
aggregated to populate the cube
- Plan aggregates not calculated correctly. I've had cases where the totals
for summary tasks do not equal the aggregate of the sub-tasks
- Plan corruption of various types, sometimes difficult to find but you
might check the differences in values from the task and resource usage views.
Adding the Actual Work Protected (or any other) column on the left pane
should equal the Actual Work Protected on the grid. I've had cases where they
didn't match and the data on the grid was used to populate the OLAP cube. The
data on the left pane is what you'll also see in the Gantt chartview.
- And some things that I've never been able to understand or get a definite
answer from Microsoft on. One of the best I've experienced is having the AWP
value in the cube equal to the AW and not the AWP value in the plan.

I've found that each of these is generally fixable, but can involve some
imagination and chicken bones.
 
H

hinesa

Thanks a heap Bill. I am using 2003. This project in particular has just
one task, I suppose that makes it a summary task, but there are no sub tasks
beneath it. The resource is assigned at 125% and that is all that I can see
that might make a difference. So if there are no subtasks then is this
considered to be a summary task?
 
B

Bill Busby

No, this is not a summary task. If you can provide the details of the
discrepancies we might be able to give a hint on how to resolve the
discrepancy.
 
H

hinesa

The project has one resource assigned at 125%. The start date is 3/14/07,
the finish date is 11/14/07. The calulcated duration is 177.5 days. The work
is 1000.75 hours.

In the PWA just viewing the project:
The work is 1000.75 hours and the duration is 172.5 days.

In the cube(Portfolio Analyzer): Using an Ad Hoc view ,

The work is 1,589.5h.

Is there something else that would be helpful? The cube has been rebuilt
after the project was re-published.


Thanks for whatever insight you can give me.

Ava
 
A

Amit khare

hello Ava,

Difference could be in the Actual work which can be because of the some actuals may be updated after cube build.
If you have custome cube or let me know the details.

happy OLAPing

Amit

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
B

Bill Busby

I suppose the first thing to start with is why do you have a resource
committed to a task at 125% of their availability for 8 months? If this isn't
accurate then let's fix that first. I take it from your post that the only
value you're concerned about it Work and that Actual Work and Actual Work
Protected are accurate.

Once you've fixed your planned effort in Work if a republish/rebuild still
has a discrepancy (and I really wouldn't spend any time worrying about the
plan showing 1775. and PWA showing 172.5... you'll find any number of slight
discrepancies between the two) I'd do the following...

Open Project Pro without the 'Load summary reource assignments', you may
need to set your connection state in the project server account to 'manually
control connection state' to see this option
In the project plan, navigate to the task usage view
On the left pane add the column for 'Work' if it's not already there
On the grid detail the style to include 'Work'
If the values are different force a recaculation
If the values continue to be different try saving the plan as an XML file
and reimporting
 
Top