Removing a Rate Table from MSP_Resource_Rates

[Debbie P]

To date when setting up resources we have entered rates only in the default
rate table '0' (field RR_RATE_TABLE). Somehow I have 2 resources in the
above table that have entries for multiple tables. The rates in those
non-zero tables are 0 and all hold from dates of 1/1/84 and to dates of
12/31/49. Is there a way to remove these entries other than deleting them
through SQL?

Thank you for your help.

 

[Guidho]

Why do you want to remove those entries?

 

[Debbie P]

The primary reason I want to remove them is they are causing hours to double
in our custom cube.

 

[Guidho]

If clearing the rates from within MS Project does not remove them, you
can only remove them from within SQL server.

Are you sure that these are causing doubles? Rates are simply
calculating the cost of a resource. It does not store hours of work.

Do you use Master Projects in your project server? As master projects
will cause doubled hours in the OLAP cube.

Hope this helps,
Guidho

 

[Debbie P]

The rates is a default rate of 0 so I can't clear them. It apparently got
created when some was on that page and saved the global enterprise resource
pool.

Our custom cube is built using a DTS package containing sql code that pulls
data from these tables to create new tables. Because the initial rate in
table A (0) has a the same date as that in table E (4) it pulls in the same
hours for each record. I have deleted the erroneous records in our
development environment and it resolves the doubling. I just hate to back
end a fix in production environments if I can prevent it.

Thank you for your help.

 

[Guidho]

You are pulling out the data of the entire table? Or based on a query.
Cause you can simply solve this by pulling out data for Rate Table A
only, by adding a WHERE RR_RATE_TABLE = 0 clause.

Like this, it just doesn't matter anymore if there is any other data in
the other rate tables.

Guidho