AnsweredAssumed Answered

Resource Baseline usage in a monthly base

Question asked by KarimD on Apr 18, 2018
Latest reply on May 14, 2018 by roland.parrotte

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

Outcomes