The Demand vs Capacity Filters tab of the Datasheet Properties, New
Datasheet, and Datasheet Type Properties dialogs is used to display the
relationship between resource capacity and demand by filtering on resource
teams and roles, allocation status and other demand. Using this tab, you can
specify the resource-related information that is included in the datasheet:
- Resource Team This tab enables you to select the resource
teams that is included on the datasheet. In the Resource Team column, select
the resource teams to include their resource demand and capacity data on the
datasheet. All resource teams are selected by default. To display a subset of
available resource teams, clear the appropriate check box(es).
- Resource Role This tab enables you to select the resource
roles that are included on the datasheet. Resource roles display as columns on
the datasheet within the specified time period. For example, if you have 5
resource roles and the selected time period is Calendar Month from January to
December, the datasheet displays 12 time periods, each of which contains five
resource role columns. To display a subset of available resource roles, clear
the appropriate check box(es).
- Allocation Status This tab enables you to select the type of
allocation that is included on the datasheet. Proposed and Committed are
selected by default. This will include both types of allocation status on the
datasheet. If you want to filter out one type or the other, clear the
appropriate check box. For example, if you want to filter out soft allocations,
clear the Proposed check box.
- Other Demand This tab enables you to define the attributes
that constitute "other demand." This demand comes from item allocations
that are outside the scope of the current datasheet, but are contained within
the same portfolio hierarchy. For example, you can include demand data from
only those items with a specific project status. Other demand can also be
items filtered out of the datasheet.