PES_MACRO_WORKITEM_ASSIGNMENT_TIMESCALE

PES_MACRO_WORKITEM_ASSIGNMENT_TIMESCALE helps you view work item assignment data, similar to how resource assignments for tasks are viewed in the Assignment and Team Roster views.

The parameters for this macro are:
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_WORKITEM_ASSIGNMENT_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)), Plan, Currency, Calendar Month, 4/1/2008, 4/30/2008, true)