Has anybody attempted to write SQL queries to generate reports that are useful for determing the capacity and availability of a resource ? The "Resource Load Breakdown" screen is a possibility but alas there is no export to Excel functionality.
Any comments or advice will be much appreciated. Thanks.
I had created report simillar to 'Resource Load Breakdown' compartible to PPM 6.0 version because of the same limitation. Capacity needs to be calculated from the WBS Scheduled efforts against resource while Demand would come from Staffing profile planned FTEs. You would have to take resource calendars into consideration while deriving capacity of the resource.
Right now I do not have those scripts with me but if you need, I can look for them.