how to get resource allocation percentages in a query using Projectweb-access?

[xz]

Using MS Project web-access 2003, I want to query the cube and - for
every project - show the same content I would see on the task-resource
name field in MS Project itself.
The problem is - I can't seem to find the fields to do this - to break
it down by task and % of resource's time allocated to that.

E.g. I'm looking for a field that produces this - for each project -
in a single query:
John Smoth[20%], Cindy Ryan[50%]


Thanks!
xz

 

[Dale Howard [MVP]]

xz --

To show task information in the OLAP cube in Project Server 2003, you must
extend the OLAP cube. You can do it yourself using the directions or you
can buy a third-party tool to assist you. To do it yourself, refer to the
following excellent white paper by Bob Segrest:

http://www.projectserverexperts.com/Downloads/Forms/AllItems.aspx

If you want to purchase a third-party application, refer to the following:

http://www.bogdanov-associates.com/eng.asp?rubr_id=484

Regarding getting the Units information, you would need to create a custom
calculation using the following formula:

[Work]/[Availability]

Hope this helps.