Skip to main content
Planview Customer Success Center

PRD31 - Product Portfolio Revenue and Cost Analysis

RPM Analytics Catalog   RPM Product Analytics   RPM Analytic PRD31  


Product portfolio report that allows the analysis of initiative/program and summarized portfolio financial plan data, including effort (FTEs/Days/Hours) or financial data (Cost/Benefit/Revenue). A single financial planning version is selected and the data type selected based on type and/or specific accounts(s). The slicer can be any strategy alternate structure or a line attribute of the selected accounts. Report can be configured to run against each level in the strategy structure. 



Business Outcomes Supporting Capabilities
  • Ensure that investment costs are balanced across strategic initiatives, across product categories, across the target markets, etc.
  • Ensure that revenue, or margin improvements, resulting from investments, are balanced across strategic initiatives,  product categories, target markets, etc.
  • Understand the risk profile of investment spend, or incremental revenue
  • Manage Product Development
  • Product Financial Management



User Parameter Configuration (Information for Planview Administrators)
Parameters Description Configuration Options Default/Example Settings
Currency Currency in which the amounts should be displayed There are several values only if the multi currency option is enabled. Default is the system default currency Defaults cannot be changed
Version Version to consider Default is the version specified in the version_id parameter (or version marked as forecast otherwise) Version_id=
Financial Measure Unit to use to display the numbers Values are:
  • Financial Amount
  • Effort (hours)
  • Effort (days)
  • Effort (FTEs)
  • Units
Correspond to the following values for the fm_measure parameter:
  • amount
  • hours
  • days
  • ftes
  • units
Financial Category Specify whether costs or  benefits/revenues should be displayed Values are:
  • Cost (cost)
  • Benefit/Revenue (benefit)
Account Types Specify the account types that should be considered This is multi select parameter Values are:
  • Capital
  • Expense
  • Labor
The first 3 values can only be selected if Financial Category=Cost Benefit can only be selected if Financial Category=Benefit
There is a line for each possible value: account_type=ACTP$EXP account_type=ACTP$CAP account_type=ACTP$LAB 
Accounts Specify the accounts that should be considered This is a multi select parameter This list takes into account the account type parameter.  Defaults to all selected. Defaults cannot be changed
Slice By Slicer to be used in the charts (and as the grouping column in the table) Contains:
  • The list of all project attributes (including WBS levels)
  • The levels of the account structure
  • Any of the line attribute
Period Starting/Ending Starting/Finishing Month for the interval Default=Horizon start of the Financial Model
Default=Horizon Finish of the Financial Model
Default cannot be changed
Chart Effort By Timescale to use for the trend chart Values are:
  • Month
  • Quarter
  • Year
Default depends on the interval size (number of periods between Period Starting and Period Ending)
Defaults cannot be changed
Max Line Attributes Number of line attributes to consider in the table   Max_line_attributes=2
Detail Table Layout Determines format of the detailed data table in the report. User can select a formatted layout, with grouping and expand/collapse, or a plan, flat-table, format that is designed for use when exporting the report to Excel for further data analysis in Excel.   Available Options are:
Default value is controlled through the table_layout parameter;



Hidden Parameter Configuration (Information for Planview Administrators)
Parameters Description Configuration Options Default/Example Settings
Table Columns 2 columns before and 2 columns after the product name can be defined The first column will be the one used as the slicer At the right end side of the table there is the Account Name, the Line Item Detail and the period columns (that contain the amounts)+ pbs_level_2_prod
Report Title Configurable report title that appears at the top of the report. If a longer report title is required, then create additional report_title=xxx entries and these will be concatenated together based on the order in which they are listed in the configuration structure. report_title=Product Portfolio Revenue and Cost Analysis


Additional Information
Details of the attributes, data types and parameters available for each report dimension:
  • X Axis – Time Periods; these periods are based on the Enterprise and Fiscal Calendar.X Axis – pie chart/bar chart stacks; this “slice by” parameter offers the ability to slice by the following data types;
    • A work (project) dimension (attribute). The available attributes are any work single select alternate structure, any WBS parent levels (above project level in the WBS).
    • A financial planning line attribute that is common to the financial planning accounts selected, for example the “Providing Organization”. This allows the detailed analysis of project financial data based on the characteristics of the financial values.
    • The financial planning account hierarchy (Account Group: Acct Level 2, Account: Acct Level 3)
  • Y Axis – Financial Value; the y axis shows data from the financial plan. The following parameters are used to determine what is shown;
    • Currency; if Planview Enterprise is configured to support multi-currency then this parameter allows selection of the currency to display the financial values in. Standard currency conversions are used.
    • Version; a single active financial plan version can be selected.
    • Financial Measure; financial planning can be used to store financial, effort and unit data. Only one measure type can be selected, to ensure that different data types are not aggregated.
    • Financial Category; selections are either “Cost” or “Revenue/Benefit”. These are determined by the financial management account configuration.
    • Account Types; Capital/Expense/Labor; based on the financial management account configuration, this parameter allows further filtering of the financial data that is aggregated for the Y Axis.
    • Accounts; this list is dynamically built based on the prior selections and shows the hierarchy of all accounts configured in the model that fit the Category and Account Type selections.
  • Max Line Attributes; this determines how the data is displayed in the table, specifically how many line attributes 


Technical/Database Information
Report (RDL) Location …/Reports/RPM/Product_RPM/RPM-PRD31/RPM-PRD31_v2.rdl
This report can be used in both a work portfolio and a single project (work-project) dashboard.
Database This report uses the transactional database and updates will be real-time
Report Developer Info RPM-PRD31_v2 RDL is a derivative of the FM31 RDL