Capacity vs. Booking Status by OBS

The Capacity vs. Booking Status by OBS report includes three charts. The line chart displays capacity compared to demand, with demand distributed by booking status, and actuals by period. The pie charts display demand by booking status and demand by employment type. The report also includes a detail listing of resource capacity and demand at the booking status level across investments. The report can be grouped by any OBS level, providing visibility into resources at any level of the organization. The report displays amounts by week or month, and in total. The amounts can be displayed as hours or FTEs.
ccppmop1541
The Capacity vs. Booking Status by OBS report includes three charts. The line chart displays capacity compared to demand, with demand distributed by booking status, and actuals by period. The pie charts display demand by booking status and demand by employment type. The report also includes a detail listing of resource capacity and demand at the booking status level across investments. The report can be grouped by any OBS level, providing visibility into resources at any level of the organization. The report displays amounts by week or month, and in total. The amounts can be displayed as hours or FTEs.
The following image shows the Capacity vs. Booking Status by OBS report displaying capacity vs. booking status summary charts.
Image displaying the Capacity vs. Booking Status by OBS report displaying capacity vs. booking status summary charts
The following image shows the Capacity vs. Booking Status by OBS report displaying capacity vs. booking status detail by investment.
Image displaying the Capacity vs. Booking Status by OBS report displaying capacity vs. booking status detail by investment.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The
    Load Data Warehouse
    and
    Load Data Warehouse Access Rights
    jobs must be run before you run this report. If the Data Warehouse is not populated, the report displays a message that there are no matching records. Also, most of the report parameters do not display options.
  • Resource capacity amounts display if the resource has availability that is defined and meets the parameter criteria.
  • Resource demand allocation amounts display if the resource is allocated to at least one investment. Resource assignments are not required.
  • The capacity amounts are calculated based on the time slices with the name MONTHLYRESOURCEAVAILCURVE and WEEKLYRESOURCEAVAILCURVE (Administration/Data Administration-Time Slices).
  • The total demand amounts are calculated based on the time slices with the name MONTHLYRESOURCEALLOCCURVE and WEEKLYRESOURCEALLOCCURVE (Administration/Data Administration-Time Slices).
  • The hard allocation amounts are calculated based on the time slices with the name MONTHLYRESOURCEHARDALLOC and WEEKLYRESOURCEHARDALLOC (Administration/Data Administration-Time Slices).
  • The soft allocation amounts are calculated as the difference between the total allocation demand amounts and hard allocation amounts. There are no soft allocation slice requests.
  • The actual amounts are calculated based on the time slices with the name MONTHLYRESOURCEACTCURVE and WEEKLYRESOURCEACTCURVE (Administration/Data Administration-Time Slices).
Report Properties
The following values list the report properties:
Name
: Capacity vs. Booking Status by OBS
Resource ID
: CSK_RES_CapVsBookingByOBS
Description
: Resource Management (PMO Accelerator)
Folder
: CA PPM/Reports/Resource Management/Capacity vs. Booking Status by OBS
Path
: /ca_ppm/reports/resource_management/CSK_RES_CapVsBookingByOBS
Data Source
: CA PPM Data Warehouse Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Resource OBS Type
resourceOBSTypeKeyRequired
Single-select
query
Resource OBS Type
resourceOBSTypeKeyRequired
Yes
Resource OBS Unit
resourceOBSUnitKeyRequired
Single-select
query
Resource OBS Unit
resourceOBSUnitKeyRequired
Yes
Resource Manager
resourceManagerKey_1
Multiple-select
query
Resource Manager
resourceManagerKey_1
No
Booking Manager
bookingManagerKey_1
Multiple-select
query
Booking Manager
bookingManagerKey_1
No
Resource Role
roleKey_1
Multiple-select
query
Resource Role
roleKey_1
No
Resource
resourceKey_1
Multiple-select
query
Resource
resourceKey_1
No
Employment Type
employmentTypeKey_1
Multiple-select
query
Employment Type
employmentTypeKey_1
No
Investment OBS Type
investmentOBSTypeKey_1
Single-select
query
Investment OBS Type
investmentOBSTypeKey_1
No
Investment OBS Unit
investmentOBSUnitKey_1
Single-select
query
Investment OBS Unit
investmentOBSUnitKey_1
No
Investment Status
investmentStatusKey_1
Multiple-select
query
Investment Status
investmentStatusKey_1
No
Start Date
startDate
Single value
date
Start Date
startDate
Yes
Start of Current Month
Period Type
periodTypeWeekMonth
Single-select
list of values
Period Type
periodTypeWeekMonth
Yes
Month
Unit Type
unitType
Single-select
list of values
Unit Type
unitType
Yes
Hours
Group By
groupOBSLevel
Single-select
list of values
Group By
groupOBSLevel
Yes
OBS Level 1
Show Investments?
showInvestments
Boolean
Show Investments?
showInvestments
No
Checked
Include Unstaffed Roles?
includeUnstaffedRoles
Boolean
Include Unstaffed Roles?
includeUnstaffedRoles
No
Unchecked
Include Inactive Resources?
includeInactiveResources
Boolean
Include Inactive Resources?
includeInactiveResources
No
Unchecked
Include Inactive Investments?
includeInactiveInvestments
Boolean
Include Inactive Investments?
includeInactiveInvestments
No
Unchecked
Show Graphs?
showGraphs
Boolean
Show Graphs?
showGraphs
No
Checked
Database Schema
dwhDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity PPM
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
The following values list the lookup values:
Project Status
: All, Approved, Unapproved
Employment Type
: Contractor, Employee
Period Type
: Week, Month
Unit Type
: FTE, Hours
Parameter Explanations
The following list describes the parameters:
  • The Resource OBS Type is a cascading parameter and determines which units are listed in the Resource OBS Unit parameter. This parameter is not used to control which resources display in the report.
  • The Resource OBS Unit parameter displays values that are based upon the Resource OBS Type selected. When you select an OBS unit in this parameter, the report displays the resources that are attached to the OBS unit and descendants of the unit you select.
  • For the capacity amounts, the resource OBS parameter filters resources based on their OBS. For the allocation demand amounts, the resource OBS parameter filters investment team members based on their staff OBS. If the staff OBS is not completed for the team members, then it filters the resources based on their OBS.
  • The Investment OBS Type is a cascading parameter and determines which units are listed in the Investment OBS Unit parameter. This parameter is not used to control which investments display in the report.
  • The Investment OBS Unit parameter displays values that are based upon the Investment OBS Type selected. When you select an OBS unit in this parameter, the report displays the investments that are attached to the OBS unit and descendants of the unit you select.
  • The Start Date parameter determines the first time period that displays in the report. There are a total of 12 periods that display on the report, starting with the period in which the start date parameter entered falls. If a date other than the first day of a monthly or weekly period is entered, then the report evaluates it to the start of the period to which the date entered belongs. For example, if you enter a start date of 01/15/2015, the report will display the first month starting on 01/01/2015. The same is true for weekly periods.
  • The Period Type parameter allows you to change the type of time periods that display across the columns of the report. This parameter works with the start date parameter to determine the periods that display on the report.
    • Week
      The report displays twelve weeks.
    • Month
      The report displays twelve months.
  • There is a Show Investments parameter that allows you to preclude individual investments from displaying in the report. If the parameter is checked, then investments display in the report to provide investment level detail of demand. If the parameter is not checked, then investments do not display in the report. In this case, the report displays resource capacity, demand, and remaining capacity amounts without the investment level detail.
  • There is an Include Unstaffed Roles parameter that allows you to include roles, which have not been staffed with resources, in the report demand allocation amounts. If the parameter is checked, then unstaffed roles are included in the report. If the parameter is not checked, then unstaffed roles are not included in the report.
  • The report has a Group By parameter that allows you to control how the report is grouped. The following group options are available:
    • OBS Level 1-10
      . This option requires that you select a unit in the resource OBS parameter to group by an OBS level. The resource OBS parameter and grouping by an OBS level work with one another. The resource OBS parameter determines which OBS you group by when you select a group by level. You can group by any OBS level from 1 to 10, which is the maximum number of levels for an OBS supported in
      Clarity PPM
      . OBS level 1 is the top level in the hierarchy and OBS level 10 is bottom level in the hierarchy. When you group by an OBS level, the resources that are attached to OBS units at the level you select and any units below the level you select are rolled up to the group by level of the report.
      If you group by an OBS level that is lower in the hierarchy, then the report groups the resources by this level (for example, OBS Level 4). If resources are associated to units above level 4 (for example, resources are attached to levels 2 and 3), then the resources that are associated to units higher in the hierarchy display in the report in an Undefined grouping. The Undefined grouping indicates that there is no OBS unit that is defined for the resource at the level by which you are grouping.
      If you group by an OBS level but you do not select a unit in the resource OBS parameter, then the report returns results. However, it does not group by an OBS level because it relies on the resource OBS parameter to determine which OBS to use for grouping.
  • The Show Graph parameter controls whether the line chart and pie charts display in the report. If the parameter is checked, the charts display on the first page of the report. If the parameter is not checked, the charts do  not display.
  • The investment statuses are displayed based on the existing investment statuses in the environment such as test, dev, or prod. For example, if there are investments with only Approved status, then only the Approved investment status displays.
Report Fields and Calculations
The report displays the capacity and demand amounts by period and in total, grouped by OBS unit. The report also displays demand amounts by investment if the show investments parameter is checked. Labor and equipment resources are included in the report; expense and material resources and roles are excluded. Roles are only included in demand allocation amounts if the Include Unstaffed Roles parameter is checked. Templates are excluded.
The capacity amounts include the capacity for resources that have an OBS unit the same as or a descendant of the resource OBS unit that is selected in the parameter. The allocation demand amounts include allocations for team staff members that have a staff OBS unit the same as or a descendant of the resource OBS unit that is selected in the parameter. If the staff OBS unit is not completed for the team members, then it uses the OBS of the resource for demand.
The demand amounts are separated into hard and soft allocations. The actual hours posted also display. When the show investments parameter is checked, the report displays hard allocations, soft allocations, and actuals by investment name.
The report displays twelve periods, starting with the period entered in the start date parameter. If the period type parameter is month, then the first day of the month in which the start date entered falls is the first monthly period displayed in the report. If the period type parameter is week, then the first date of the week in which the start date entered falls is the first weekly period displayed in the report. Weekly periods are calculated based on the first day of the work week.
The remaining capacity field on the report has a red background if the value is a negative number, no background if the value is zero, and a green background if the value is a positive number. The amounts being converted to FTE depend on the Data Warehouse calendar table.
When the show graph parameter is checked, the report also includes a line chart and two pie charts. The line chart displays capacity compared to demand, with demand distributed by booking status, and actuals by period. The pie charts display demand by booking status and demand by employment type.
Report Security
Security is determined by resource view rights.