That uses the system data provider Team allocations. I take that to mean prteam and allocation coming from prteam.prallocasum, prteampralloccurve and prteam.hard_curve and blobs are cracked on the fly if needed.
You can get what is actually used as queries with SLQ trace. The result may be a little different depending on what you have displayed. Below are two examples.
You could also build queries from scratch and use the slices.
Martti K.
select from (select row_number() over ( order by requirement_name asc ) odf_row_num, count() over (partition by pmd_analytical_partition_by) odf_num_rows,
q. from ( select 'x' pmd_analytical_partition_by, prteam.prid odf_pk , INV_INVESTMENTS.odf_object_code COLLATE Latin1_General_CI_AS_KS investment_type ,
CASE WHEN PRJ_RESOURCES.PRISROLE = 1 THEN ISNULL(PRTEAM.REQUIREMENT_NAME,SUBSTRING(SRM_RESOURCES.FULL_NAME,1,100))
ELSE SRM_RESOURCES.FULL_NAME END COLLATE Latin1_General_CI_AS_KS requirement_name , prteam.prAvailStart pravailstart ,
prteam.prProjectID prprojectid, (select top 1 name from ( SELECT INV.ID ID
,INV.CODE CODE
,INV.CODE UNIQUE_CODE
,INV.NAME NAME
,INV.ODF_OBJECT_CODE OBJECT_CODE
FROM INV_INVESTMENTS INV LEFT OUTER JOIN INV_PROJECTS PRJ ON INV.ID = PRJ.PRID
WHERE
1=1
AND ISNULL(PRJ.IS_TEMPLATE,0)=0
AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)
AND
1= 1--1
and 1=1) q where q.id = prteam.prProjectID) prprojectid_caption , PRJ_RESOURCES.PRISROLE isrole , prteam.prResourceID prresourceid,
(select top 1 full_name from ( SELECT SRM_RESOURCES.ID ID,
SRM_RESOURCES.LAST_NAME LAST_NAME,
SRM_RESOURCES.FIRST_NAME FIRST_NAME,
SRM_RESOURCES.FULL_NAME FULL_NAME,
SRM_RESOURCES.UNIQUE_NAME UNIQUE_NAME,
SRM_RESOURCES.UNIQUE_NAME UNIQUE_CODE
FROM SRM_RESOURCES, PRJ_RESOURCES WHERE
1=1 AND
1= 1--2
and 1=1 AND SRM_RESOURCES.ID=PRJ_RESOURCES.PRID) q where q.id = prteam.prResourceID) prresourceid_caption , SRM_RESOURCES.DATE_OF_HIRE prdoh ,
INV_INVESTMENTS.NAME COLLATE Latin1_General_CI_AS_KS project_name , prteam.prRoleID prroleid, (select top 1 prname from ( SELECT PRJ_RES.PRID PRID,
PRJ_RES.PRUID UNIQUE_CODE, SRM_RES.FULL_NAME PRNAME
FROM PRJ_RESOURCES PRJ_RES
, SRM_RESOURCES SRM_RES
WHERE PRJ_RES.PRISROLE != 0
AND PRJ_RES.PRID = SRM_RES.ID
AND 1=1
AND 1= 1--3
and 1=1) q where q.prid = prteam.prRoleID) prroleid_caption , SRM_RESOURCES.DATE_OF_TERMINATION prdot , prteam.prAvailFinish pravailfinish
, prteam.HARD_FINISH hard_finish , odf_ca_team.partition_code COLLATE Latin1_General_CI_AS_KS partition_code
, (select b.name from cmn_partitions a,cmn_captions_nls b where a.id = b.pk_id and b.table_name = 'CMN_PARTITIONS' and b.language_code = 'en'--4
and a.code = odf_ca_team.partition_code union select name from cmn_captions_nls where pk_id = -1 and table_name = 'CMN_PARTITIONS' and language_code = 'en'--5
and 'NIKU.ROOT' = odf_ca_team.partition_code) partition_code_caption , prteam.prBooking prbooking
, (select top 1 NAME from cmn_lookups_v where language_code = 'en'--6
and lookup_type = 'BOOKING_STATUS_LIST'--7
and LOOKUP_ENUM = prteam.prBooking) prbooking_caption
, CASE WHEN SRM_RESOURCES.RESOURCE_TYPE 2
THEN PRTEAM.PRALLOCSUM 3600 niku.PRJ_HPD_FACTOR_FCT()
ELSE PRTEAM.PRALLOCSUM
END prallocsum , SRM_RESOURCES.EMAIL COLLATE Latin1_General_CI_AS_KS email
, INV_INVESTMENTS.SCHEDULE_FINISH projectfinish , INV_INVESTMENTS.SCHEDULE_START projectstart
, prteam.HARD_START hard_start , SRM_RESOURCES.FULL_NAME COLLATE Latin1_General_CI_AS_KS full_name
, SRM_RESOURCES.RESOURCE_TYPE restype, (select top 1 NAME from cmn_lookups_v where language_code = 'en'--8
and lookup_type = 'RESOURCE_TYPE'--9
and LOOKUP_ENUM = SRM_RESOURCES.RESOURCE_TYPE) restype_caption
, ISNULL(prteam.pravailstart, inv_investments.schedule_start) pravailstart_sort
, ISNULL(prteam.pravailfinish, inv_investments.schedule_finish) pravailfinish_sort from odf_ca_team
, PRTeam LEFT OUTER JOIN PRJ_BASELINE_DETAILS BASEREC ON PRTeam.PRID = BASEREC.OBJECT_ID
AND BASEREC.OBJECT_TYPE='TEAM' AND 1 = BASEREC.IS_CURRENT
, INV_INVESTMENTS LEFT OUTER JOIN INV_PROJECTS ON INV_INVESTMENTS.ID = INV_PROJECTS.PRID
, SRM_RESOURCES, PRJ_RESOURCES,SRM_RESOURCES CREATED, SRM_RESOURCES UPDATED
,(select 'x' pmd_analytical_partition_by, inv_investments.id odf_pk, odf_ca_inv.master_sub master_sub
from inv_investments, odf_ca_inv where 1 = 1 and inv_investments.id = odf_ca_inv.id) prprojectid
where INV_INVESTMENTS.ID=PRTeam.prProjectID
AND SRM_RESOURCES.ID=PRTeam.prResourceID
AND PRJ_RESOURCES.PRID = SRM_RESOURCES.ID
and PRTEAM.CREATED_BY = CREATED.USER_ID AND PRTEAM.LAST_UPDATED_BY = UPDATED.USER_ID
and PRTeam.prProjectID = prprojectid.odf_pk and prteam.prid = odf_ca_team.id and 1=1 and 1=1 and 1=1
and 1=1 and 1=1 and INV_INVESTMENTS.IS_ACTIVE = 1--10
and PRJ_RESOURCES.PRISROLE = 0--11
and SRM_RESOURCES.IS_ACTIVE = 1--12
and ISNULL(INV_PROJECTS.IS_TEMPLATE,0) = 0--13
and CASE WHEN INV_INVESTMENTS.STATUS = 1 OR INV_INVESTMENTS.STATUS = 5 THEN 1 ELSE 0 END = 1--14
and SRM_RESOURCES.RESOURCE_TYPE = 0--15
) q) q where q.odf_row_num between 1--16
and 20--17
order by q.odf_row_num
----------------------------------------------------------------------------------------------
weekly detail query 2 slice values from the insta slices
SELECT PRTEAM.PRID ID
, periods.start_date PERIOD
, SUM(slices.slice) TOTAL
FROM PRJ_BLB_SLICES_W_ALC slices
,(SELECT WEEK_KEY
, min(day) start_date
, max(day) end_date
FROM nbi_dim_calendar_time
WHERE day = '2012-12-03 000000.0'--1
AND day '2013-01-14 000000.0'--2
GROUP BY WEEK_KEY
) periods
, INV_INVESTMENTS
, PRTEAM
, SRM_RESOURCES RS
, PRJ_RESOURCES PRES
WHERE slices.SLICE_DATE = periods.start_date
AND
slices.SLICE_DATE = periods.end_date
AND
slices.SLICE_DATE = '2012-12-03 000000.0'--3
AND slices.SLICE_DATE '2013-01-14 000000.0' --4
AND slices.PRJ_OBJECT_ID = PRTEAM.PRID
AND RS.ID = slices.RESOURCE_ID
AND PRES.PRID = slices.RESOURCE_ID
AND INV_INVESTMENTS.ID = slices.INVESTMENT_ID
AND
ISNULL((SELECT IS_TEMPLATE FROM INV_PROJECTS WHERE INV_PROJECTS.PRID = INV_INVESTMENTS.ID), 0) = 0
AND INV_INVESTMENTS.IS_ACTIVE = 1--5
AND PRTEAM.PRID
IN (5000209,5000179,5000182,5000187,5000176,5000175,5000188,5000140,5000153,5000166,5000141,5000164,5000233,5000151,5000142
,5000220,5000152,5000148,5000149,5000138) GROUP BY PRTEAM.PRID, periods.start_date
.