Program Milestone Dependencies

ccppmop1561
The Program Milestone Dependencies report displays programs and their inter-project predecessor milestone dependencies. This gives you visibility between your program milestones and predecessor-dependent milestones in other projects. The report displays dependencies as a diagram, and a detailed list. The diagram displays a maximum of five predecessor dependencies to your program. The detailed list does not have this limit and shows all predecessor dependencies. The report contains program summary and milestone information, including a dependency schedule stoplight and finish dates. It also includes a checkmark icon indicating that the milestone or dependent milestone is on the critical path.
The following image shows the Program Milestone Dependencies report displaying programs and their inter-project predecessor milestone dependencies.
Image displaying the Program Milestone Dependencies report displaying programs and their inter-project predecessor milestone dependencies.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The program must have at least one milestone with a dependency to a milestone in a separate project to display in the report.
  • For the program summary section, the program must have budgeted or planned cost that is entered on the financial summary of the program. If the program has a detailed budget or cost plan, then the approved budget amount or cost plan amount for the plan of record displays based on the financial plan type parameter that is selected when running the report.
Report Properties
The following values list the report properties:
Name
: Program Milestone Dependencies
Resource ID
: CSK_PRG_MilestoneDependencies
Description
: Program Management (PMO Accelerator)
Folder
: CA PPM/Reports/Program Management/Program Milestone Dependencies
Path
: /ca_ppm/reports/program_management/CSK_PRG_MilestoneDependencies
Data Source
: CA PPM 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
Program OBS Type
programOBSTypeKey_1
Single-select
Query
Program OBS Type
programOBSTypeKey_1
No
Program OBS Unit
programOBSUnitKey_1
Single-select
Query
Program OBS Unit
programOBSUnitKey_1
No
Program Manager
programManagerKey_1
Multiple-select
Query
Program Manager
programManagerKey_1
No
Program
programKey_1
Multiple-select
Query
Program
programKey_1
No
Program Status
programStatusKey_1
Multiple-select
Query
Program Status
programStatusKey_1
Yes
Approved, Cancelled, On Hold, Unapproved
Work Status
workStatusKey_1
Multiple-select
Query
Work Status
workStatusKey_1
No
Financial Plan Type
financialPlanTypeKey_1
Single-select
List of Values
Financial Plan Type
financialPlanType
Yes
Budget
Milestone From
milestoneFrom
Single Value
Date
Milestone From
milestoneFrom
No
Milestone To
milestoneTo
Single Value
Date
Milestone To
milestoneTo
No
Show Grid Detail?
showGridDetail
Boolean
Show Grid Detail?
showGridDetail
No
Checked
Include Inactive Programs?
includeInactivePrograms
Boolean
Include Inactive Programs?
includeInactivePrograms
No
Unchecked
Include Inactive Projects?
includeInactiveProjects
Boolean
Include Inactive Projects?
includeInactiveProjects
No
Unchecked
Database Schema
ppmDBSchema
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:
Program Status
: Approved, Cancelled, On Hold, Unapproved
Work Status
: Requested, Active, On Hold, Cancelled, Complete
Financial Plan Type
: Budget, Planned
Parameter Explanations
The following list describes the parameters:
  • The Program OBS Type is a cascading parameter and determines which units are listed in the Program OBS Unit parameter. This parameter is not used to control which programs display in the report.
  • The Program OBS Unit parameter displays values that are based on the Program OBS Type selected. When you select an OBS unit in this parameter, the report displays the programs that are attached to the OBS unit and descendants of the unit you select.
  • The Work Status parameter is associated to the Work Status lookup in PPM. This lookup is configurable so lookup values might be added, modified, or deactivated.
  • The Financial Plan Type parameter allows you to select which type of financial plan cost amount to display in the program summary section of the report. You might run the report to display the budgeted or planned cost amount that is entered on the financial summary of the program. If the program has a detailed budget or cost plan, then the approved budget amount or cost plan amount for the plan of record displays. The Financial Plan Type parameter works as follows:
  • Budget
    The report displays budgeted cost. The preceding screen capture was run with the option of planned. If it is run with the option of budget, then it displays the word "budgeted" where it displays the word "planned" in the program summary section of the report.
  • Planned
    The report displays planned cost. The above screen capture displays planned cost in the program summary section because this is the parameter value that is selected when running the report.
  • The Milestone From and Milestone To parameters determine the finish date of the milestones that display in the report. If dates are entered, the report includes milestones with finish dates within the range of dates that are entered in the parameters. This allows you to control which inter-project dependencies display in the report. The diagram displays a maximum of five predecessor dependencies, but you can leverage the date parameters to determine which appear if you have more than five dependencies.
  • The Show Grid Detail parameter controls whether the dependencies displayed in the diagram also display in a table below the diagram. The diagram displays a maximum of five predecessor dependencies. The detailed table does not have this limit and shows all inter-project dependencies. If the parameter is checked, a table showing the dependencies display below the diagram for each program. If the parameter is not checked, the tablel does not display.  
Report Fields and Calculations
The report displays the program name, program ID, program manager, work status, start date, finish date, planned or budgeted cost, and objective in the program summary section. The report has a financial plan type parameter, allowing you to select whether to display the planned or budgeted cost.
The report displays only programs with inter-project predecessor milestone dependency relationships. The report includes a diagram as a visual representation of these inter-project dependencies. The diagram uses rectangles to represent the program and its dependent projects. The program is at the top of the diagram; the predecessor projects are located below the program. The dependency relationships are represented by lines connecting dependent projects to the program, with the arrows pointing from the predecessor projects to the successor program. The diagram displays a maximum of five predecessor projects. If there are more than five inter-project dependencies, the diagram displays the first five projects in alphabetical order. The other dependencies display as part of the grid when you select the Show Grid Detail parameter. The report also has Milestone From/To parameters to control which inter-project dependencies display in the report.
When the Show Grid Detail parameter is checked the report includes a table that displays information about each project dependency that is associated to the program. The project dependency information is displayed in the first five columns and includes: dependent project name, dependent project ID, dependent milestone name, dependency schedule stoplight, and dependent milestone finish date. The program information is displayed in the last two columns and includes: milestone name and milestone finish date. The program name displays above these columns. The report also displays a checkmark icon, to the right of milestone name, indicating that the program milestone or dependent milestone is critical. Templates are excluded.
This report contains the following calculations:
  • Dependency Schedule.
    The dependency schedule stoplight is the number of days the milestone is late and considers the following:
    • Whether a baseline exists
    • Milestone status
      If a baseline exists, then days late is calculated as milestone finish date minus baseline finish date. A positive number indicates that the milestone is late according to the baseline. A negative number indicates that it is early according to the baseline.
      If a baseline exists and the milestone finish date is the same as the baseline finish date, then the milestone is considered late if it is not completed and it was due before today's date. In this case, days late is calculated as today's date minus milestone finish date.
      If there is no baseline, then days late is calculated if the milestone is not completed and it was due before today's date. In this case, days late is calculated as today's date minus milestone finish date. 
      Dependency Schedule stoplight color is determined as follows:
Green= On Schedule (<=0)
Red= Late (>0)
  • Dependency Diagram
    . The dependency diagram uses rectangles to represent the program and its dependent projects. The program is at the top of the diagram; the predecessor projects are located below the program. The color of the rectangle for the dependent projects is determined by the dependency schedule stoplight of their milestones. If a dependent project has at least one milestone with a red dependency schedule stoplight, then the rectangle in the diagram is red for that dependent project.
    The color of the rectangle for the program is based on the program schedule, which is the number of days the program is late, and considers program progress as follows:
    Days late is calculated if the program is not completed and it was due before today's date. The number of days late is calculated as today's date minus program finish date.
    Schedule color is determined as follows:
Green= On Schedule (<=0)
Red= Late (>0) 
Report Security
Security is determined by project view rights.