PES_MACRO_RESOURCE_ALLOCATION

PES_MACRO_RESOURCE_ALLOCATION_TIMESCALE helps you view resource allocation data, similar to how resource allocation is viewed in the Allocation and Team Roster views.

The parameters for this macro are:

Temporary table name
WHERE clause applied against the PES_ResourceAllocation table so only those allocationsare normalized.
Storage unit The possible values are ‘FTE’, ‘Currency’, ‘Hours’. (Note: only attributes that are coercible to this storage unit are returned.)
Time scale The possible values are ‘Calendar Year’, ‘Calendar Quarter’, ‘Calendar Month’, ‘Calendar Week’, ‘Calendar Day’, ‘Fiscal Year’ and ‘Fiscal Quarter’.
Finish date Similar to Start Date the entire bucket containing this date will be included.
Use date format The possible values are true and false. If true then the column names for the buckets will be yXXXX_mXX_dXX. If false then the column names for the buckets will be PX.

The following example shows how to find the cost of all resource allocations made from a single resource team during the month of April, 2008:

SELECT * FROM PES_MACRO_RESOURCE_ALLOCATION_TIMESCALE(ra, obj_ResourceUID
IN (SELECT resource.obj_UID FROM PES_Object peso JOIN PES_Resource resource
ON peso.obj_UID = resource.obj_ParentUID and resource.obj_ParentUID
in (SELECT oa_DescendantUID FROM PES_ObjectAssociation WHERE oa_AncestorUID = 3)),
 Currency, Calendar Year, 4/1/2008,4/30/2008, true)