Task Time Dimensions for Work Assignments

[dlsnyder]

Where can I find (what database file / field(s)) the hours by week dimension
at the resource task level ?

I can see the data I want in PWA when I select a resource and go to the time
sheet format - I can switch between week / month / total. Where is hours by
week stored?

 

[Kim Ralls]

HI,
In PWA 2003 this is not possible.

 

[dlsnyder]

Are you saying it is not stored but calculated on the fly?
Please explain your response.
Thanks

 

[Ben Howard]

Hi,
Task information is not held in the cube by unless you extend the cube,
therefore what you require from Portfolio Analysis is just not available.
Information is only held at resource / project level.

There are several commercial cube extenders, or you can write your own -
details are in the SDK.

 

[dlsnyder]

Not talking about the cube here. I'm looking at at the web view of a project
(like on a time card where resources see there assignments in PWA). In that
view hours can be seen at the task view in daily, weekly, total time
dimensions at the task level.

So information is available at the task level in various time dimensions.
The question is - is the dimension data stored, or is it calculated on the
fly when you pick week or day?

 

[Ben Howard]

I don't know, you'd have to trawl the SQL tables for the answer.