AnsweredAssumed Answered

Query to find actuals by manager "hierarchy"

Question asked by vtleogal2 on May 15, 2014
Latest reply on Feb 16, 2015 by vtleogal2

I performed quite a few searches on here and I did not find what I was seeking, so I apologize if this is indeed posted somewhere. I need some help getting started with trying to find actuals by resource based on the manager hierarchy.

Example,

Mr. VP = VP and has  3 Managers:  Mgr 1, Mgr 2 and Mgr 3 under him

Mr VP thus has 3 direct reports (and we will assume they log time)

Each Manager has 10 employees  : 5 contractors and 5 employees. All log time

Trying to find the relationship to get actuals logged by the lowest level resource at the VP level to show the VP, his direct reports and their direct reports' actuals. I have never seen this out of the box (we are 12.1, but have 13.3 in test and still don't see it with the Content or PMO packages), so is this possible? If so, any suggestions on how to jump start the query/ ( I have the simple queyr of showing resources and their associated manager).  Or, is there a better way to get it than through a query? We do not use business Objects.

Dont need details at the task level, just a summary of hours and perhaps by time period or be able to constrain on time period for the where clause.

Thanks in advance

Lynn

Outcomes