Project Server 2007 OLAP cubes

[MSPLearner]

When comparing Work, Actual Work and Remaining work in Project Center with
OLAP Cube (Portfolio Analyzer Cube), I see small differences. The differences
seem to point to Work, Actual, Remaining Work NOT captured in the cube for
inactive Resources. That does not make sense. Resources on-board/off-board
all the time in a large program, there work has to accounted for the life of
the program, regardless.

Questions

1) Are inactive Resources filtered out in OLAP cubes (what is the default
rule)?
2) Where can I look for documentation?
3) If indeed (1) is the problem above, what are the steps to change it?

Thanks in advance.

MSPlearner

 

[Marc Soester [MVP]]

Hi MSPLearner,

Inactive resources usually stay in the cube, you can actually filter them
out based on resource dimensions,

There is quite a lot of inforamtion regarding the OLAP cubes on the TechEd
page from Microsoft. This is a good starting point
http://technet.microsoft.com/en-us/library/cc303399.aspx

Hope this helps

 

[MSPLearner]

Thanks Marc,

In the Portfolio Analyzer Cube, when I add up work,actual work etc across,
the totals do not match what's on Project Center. The difference exactly
matches the work, actual etc for Inactive Resources. It appears that when the
cube is built, it filters of assignment information for inactive resources.

 

[C_A_D]

check something - if you open the Resource Record for an inactive
resource so that it opens the record in winproj, please confirm the
Resource Type for this resource.

note - you need to check i winproj, not PWA

 

[C_A_D]

check something - if you open the Resource Record for an inactive
resource so that it opens the record in winproj, please confirm the
Resource Type for this resource.

note - you need to check i winproj, not PWA

to add - it is posisble the resoure will show as MATERIAL.... if so
switch this back to WORK and then retry the cube build

 

[Marc Soester [MVP]]

Hi MSPLearner, hmmmm I am not sure why you have this issue. Generally
inactive users keep the value. Do you have any error logs for hte cube build?

 

[C_A_D]

I am aware of an issue with inactive resources becoming Material
Resources in some cases
when they become material resources, work is removed from RDB
these MAterial setting is only viewable in WinProj client not pwa so
is not immediately obvious

let me know what you find

 

[MSPLearner]

C_A_D,

Your hunch is somewhat correct.

In my sample study, of the three material resources, two are included in
OLAP, the third is not. All three are Inactive.

Thanks for you help. We are closing in on the root cause.

I also noticed that the Assignment & Assignment-By-Day table's Work, Actual
Work are not the same for some plans. I believe they should be. It appears
OLAP is building from Assignment table, while Project Center data comes from
Assignment-By-Day table.