AnsweredAssumed Answered

allocations using timeslices?

Question asked by Riya on May 25, 2011
Latest reply on May 25, 2011 by Dave
Hello, How can i find allocations for each week. I tried to create a query to check in time slices table and i used daily allocation time slice 10.

Here is my Query. Is this correct? Please let me know.

SELECT I.ID,
I.NAME,
R.FULL_NAME AS MANAGER,
SUM(slice) AS ALLOCATED

FROM NIKU.INV_INVESTMENTS I,
NIKU.SRM_RESOURCES R,
NIKU.PRTEAM TP,
NIKU.PRJ_BLB_SLICES S
WHERE I.MANAGER_ID = R.USER_ID
AND I.ID = TP.PRPROJECTID
AND S.PRJ_OBJECT_ID = tp.PRID
AND SLICE_REQUEST_ID = 10
GROUP BY
I.ID,
I.NAME,
R.FULL_NAME

I tried to compare the result by just summing PRTEAM allocations, the total allocated hours doesn't match.

Please let me know.

Thank you
RK

Outcomes