If they are using My Tasks and submitting time to the PM's for approval and
getting those hours approved and loaded into the schedule and then
re-published back out, you could create a data analysis view using the
MSP_Portfolio_Analysis Cube that shows the resource actual hours vs. planned
hours and/or baseline hours along with any project or resource custom field
information. For example, if you have a custom lookup table that specifies
who the manager is, then you could use that to filter the resource
information for each manager by that value. Or you could use the RBS values
if you set up an RBS in your environment
However, if you are only using My Timesheets, you will have to do a Data
Analysis view using the Timesheet cube which has very limited project and
resource information. It only has the project name and resource name and no
other project or resource related information. Also, since it is taking
snapshots of the resource and project data at the time of the timesheet
creation, you could potentially have different project name or resource name
information if the project name or resource name has changed during
production use.
Jonathan
