Must I republish all projects to get new resource rates in OLAP?

[rt]

We have adjusted resource rates in the resource pool of PS2003; the
changes affect multiple resources since July 2006.

When I open a plan, I can see that the new rates are applied (e.g. in
actual cost column), don't have to do anything about that.

In the portfolio analyzer, however, the new rates are not applied.

Do I have to republish all projects before running the OLAP?

The reason I ask is this: we are in the middle of year end close and
the cube is not building correctly (known problem). I need to know
whether to focus on:

1. solving the cube problem > republishing all projects > pulling the
correct data from the portfolio analyzer, or

2. Pull actual work from current OLAP > copy-paste rates from resource
pool > do some juggling in Excel

A clear answer would help me set priorities and get the data to
finance on time

 

[Marc Soester [MVP]]

H rt,

once you have changed the rates in the cost rate table, you will need to
open the proejcts where the resource is assinged to, recalculate ( F9) and
republish the projects. After you have done so, rebuild the cube and the new
values will appear
Hope this helps

 

[rt]

H rt,

once you have changed the rates in the cost rate table, you will need to
open the proejcts where the resource is assinged to, recalculate ( F9) and
republish the projects. After you have done so, rebuild the cube and the new
values will appear
Hope this helps

Thanks Mark. What I don't understand is the F9 action. When I open a
project without doing anything else, I can already see the new rates
applied?

 

[Hung]

I have a rather similar question on this:
If I change the resource rate today, but I want it to be effective since the
beginning of the year (ie. recalculate all the number), do I need to do all
these recalculation and republishing for all the projects and how can I
specify the date when this new rate should be effective?

Thanks
Hung

 

[Marc Soester [MVP]]

HI,

the F9 button recalculates the project.
Yes you will need to re-open your proejct, save the new change and republish
it.
Hung, you can apply the effective date whtin the cost rate table section.
That will calculate your cost from the date you have chosen.
hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com