Hello all,
I am building a query to get the resource baseline usage in a monthly base as we can do it on Actuals and ETC.
I tried to use this slice MONTHLYCURRENTBASEPROJUSAGE but the query did not return any data. below the query that I built :
SELECT
II.NAME AS PROJECT_NAME,
PB.NAME AS BASELINE,
SR.FULL_NAME AS RESOURCE_NAME,
SUM(ISNULL(BASE.SLICE,0)/8 ) AS BASE_USAGE,
BASE.SLICE_DATE,
BASE.PRJ_OBJECT_ID
FROM INV_INVESTMENTS II
LEFT OUTER JOIN PRTASK PT ON II.ID=PT.PRPROJECTID
LEFT OUTER JOIN PRASSIGNMENT PA ON PT.PRID=PA.PRTASKID
LEFT OUTER JOIN PRJ_BASELINE_DETAILS PBD ON PA.PRID=PBD.OBJECT_ID
LEFT OUTER JOIN PRJ_BASELINES PB ON PBD.BASELINE_ID=PB.ID
LEFT OUTER JOIN SRM_RESOURCES SR ON PA.PRRESOURCEID=SR.ID
LEFT OUTER JOIN (SELECT PBS.PRJ_OBJECT_ID,
PBS.SLICE SLICE,
PBS.SLICE_DATE SLICE_DATE,
PBSR.REQUEST_NAME
FROM PRJ_BLB_SLICES PBS, PRJ_BLB_SLICEREQUESTS PBSR
WHERE PBS.SLICE_REQUEST_ID=PBSR.ID
AND PBSR.REQUEST_NAME IN ('MONTHLYCURRENTBASEPROJUSAGE ')) BASE ON PA.PRID=BASE.PRJ_OBJECT_ID
WHERE PBD.OBJECT_TYPE='ASSIGNMENT'
GROUP BY
II.NAME,
PB.NAME,
SR.FULL_NAME,
BASE.PRJ_OBJECT_ID,
BASE.SLICE_DATE
Do you have any ideas ?
Thank you in advance,
Karim