I've been toying with the Resource Planner myself too. The objective being the production of a resource management dashboard showing budgeted hours vs planned hours side-by-side a report for planned hours vs actual hours with each of those reports being grouped by program and by person. Unfortunately, the Budgeted Hour business object is not available in reporting. As far as I can tell, the only thing close is the "Resource Planner Budgeted Labor Cost" which calculates the hours planned and $$/hr rate of the role assigned in aggregate for all the resources, roles and hours assigned in the resource planner. All our work in Resource Planner distills down to a single project level cost field. I tricked the system to give me hours by setting the role to have a $1/hour cost, which results in "Resource Planner Budgeted Labor Cost" actually being equivalent to the hours budgeted. Obviously not a feasible solution if you care about cost at all. I then attempted to use a custom, calculated field on tasks to determine the task's proportional amount of budget hours, but data integrity is lost because of the project level aggregation of the resource plan. If I put 40 budgeted hours in for person X and 80 budgeted hours in for person Y I'd correctly get 120 hours at the project level, but any attempt to report out how much of that 120 was person X vs person Y failed my litmus tests. Not sure where to go from here. I can easily imagine a text-mode heavy solution if I had access to that darn BudgetedHour business object in reporting! Rick MacDuffie Symetra Life Insurance Company
