Good Day. I have an hardly task: i need resive date of schedule from task for resources (same possibility allow from assignmen resource load portlet) sach as actual date form TS. I know effort and duration. Effort.day=effort/duration.How can i get date for this effort. Thanks in advice
Hi! I mean that i need resive date of schedul effort sach as date of actual effort from TS. I don't know how it's possible but allow good example - analize assignment load portlet with periobs-day. This portlet show scheduled efoort ti each day. Any ideas? Thanks in advice
I'f I understood you right you want to get ammount of scheduled hours for certain resource with certain task at certain day.
Formula "1 Day effort = Total Effort/Duration in days" is not very correct since we do not take into account personal and regional calendars in here. If you want to take into account personal and regional calendars while calculating scheduled effort per day per resource per task it is not a trivial task and will require some programming.
The reference documentation says it stores both: This table contains a copy of all the Assignment information from Projects, Requests, and Staffing Profiles. The relevant data is de-normalized (and preprocessed) into this table and kept up to date asynchronously by the server. This table serves as the data source for the Workload information in the Resource Management visualizations (available from the Resource Management menu).
So far we only used the standard means (assignment load page), so I did not use the data in the table myself yet.
Thanks for All. But my task is: user |date | Schedule Effort semenov-as|01/02/2009| 2 semenov-as|02/02/2009| 2 semenov-as|03/02/2009| 2 and next... This inf need for sending it's(effort/per day) to cross tab and resive schedul load for variouse periods. For example if i need resive schedul efforf from 02.06.2009 to 31.12.2009 i need: -or do 6 runs of report -or do 6 subreport
For actual effort task is complet: each ect eff have date. But shed effort have't this date and i can resive datas only for any range with useng very mush formulas. Any ideas? Thanks