Has anyone figured out which data elements should be used to produce a report showing planned and actual effort and cost by period (week or month) in the new WI reporting environment? I've spent a lot of time trying to verify the data elements from Project Information/Task Detail/Date Groups where I've used the 'Week' and 'Task Work Hours' fields, but can't reconcile the output to my project plan online. I also can't determine how the data model calculates the weekly spread of planned effort. In some cases it appears it's taking the total planned effort/duration * # days in week and in other cases it's taking the Resource Utilization % * hrs/in week for task assignment. Regardless, I can't verify the data model w/the project plan to validate the numbers. Wondering if there are other data elements or more advanced ARB functions to use?
Thanks, Susanne