Product or Application Roadmap

ccppmop159
The Product or Application Roadmap report lists milestones from projects allocated to products or applications and their Gantt schedule covering a timeframe. The timeframe can be twelve months or four quarters. The report can be grouped by any combination of the following options:
  • Application
  • Product
  • Manager
The following image displays the Product or Application Roadmap report listing project milestones and their Gantt schedules covering a timeframe.
 
The image displays the Product or Application Roadmap report listing project milestones and their Gantt schedules covering a timeframe
 
 To avoid performance issues, run the report after specifying the parameters to limit the amount of data retrieved. 
 
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.
  • The product must have projects allocated through the hierarchy and the child projects must have milestones. 
  • The application must have projects allocated through the hierarchy and the child projects must have milestones.
  • Milestones must have the milestone and key task fields selected to display in the report.
 
Report Properties
 
The following values list the report properties:
 
Name:
 Product or Application Roadmap
 
Resource ID:
 CSK_INV_Roadmap
 
Description:
 Investment Management (PMO Accelerator)
 
Folder:
 
Clarity
/Reports/Investment Management/Product or Application Roadmap
 
Path:
 /ca_ppm/reports/investment_management/CSK_INV_Roadmap
 
Data Source:
 
Clarity
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
Product or Application OBS Type
productApplicationOBSTypeKey_1
Single-select query
Product or Application OBS Type
productApplicationOBSTypeKey_1
No
Product or Application OBS Unit
productApplicationOBSUnitKey_1
Single-select query
Product or Application OBS Unit
productApplicationOBSUnitKey_1
No
Product or Application Manager
productApplicationManagerKey_1
Multiple-select query
Product or Application Manager
productApplicationManagerKey_1
No
Product or Application
productApplicationKey_1
Multiple-select query
Product or Application
productApplicationKey_1
No
Start Date
startDate
Date
Start Date
startDate
Yes
Period Type
periodTypeMonthQuarter
Single-select list of values
Period Type
periodTypeMonthQuarter
No
Quarter
Group By
groupManagerApplicationProduct
Single-select list of values
Group By
groupManagerApplicationProduct
Yes
Application
Include Inactive Investments?
includeInactiveInvestments
Boolean
Include Inactive Investments?
includeInactiveInvestments
No
Unchecked
Database Schema
dwhDBSchema
Hidden
Not applicable
Yes
Passed through 
Classic PPM
 
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through 
Classic PPM
 
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through 
Classic PPM
 
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through 
Classic PPM
 
 
 
Parameter Lookup Values
 
The following values list the lookup values:
 
Period Type:
 Month, Quarter
 
Parameter Explanations
 
The following list describes the parameters:
  • The Product or Application OBS Type is a cascading parameter and determines which units are listed in the Product or Application OBS Unit parameter. This parameter is not used to control which projects display in the report.
  • The Product or Application OBS Unit parameter displays values that are based on the Product or Application OBS Type selected. When you select an OBS unit in this parameter, the report displays the products or applications that are attached to the OBS unit and descendants of the unit you select.
  • The Start Date parameter allows you to control the starting period that displays in the report.
  • The report has a Period Type parameter that allows you to change the display periods of the Gantt.
 
Month.
 The Gantt displays twelve months.
 
Quarter.
 The Gantt displays four quarters.
  • The report has a Group By parameter that allows you to control how the report is grouped. You can group the report by the following grouping options:
 
Application.
 This option groups projects by application.
 
Product.
 This option groups projects by products.
 
Manager.
 This option groups project by product or application and by manager.
 
Report Fields and Calculations
 
The report adjusts the column headings and content according to the values selected in the Group By parameter. If the report is grouped by product or application, then the report displays the following columns: product or application name, and twelve monthly periods or four quarterly periods. If the report is grouped by manage, then the report displays the following columns: product or application name, project, and twelve monthly periods or four quarterly periods. Milestones are not rolled up to the product or application level. Programs are included, templates are excluded.
The milestone stoplight color is determined as follows:
  • Gray = Completed
  • Green = Started
  • Blue = Not Started
 
Report Security
 
Security is determined by investment view rights.