Skip to main content

 

Planview Customer Success Center

PRD32 - Product Revenue/Cost Forecast Performance

RPM Analytics Catalog   RPM Product Analytics   RPM Analytic PRD32 

 

Overview
Single product and product portfolio report that allows the comparison of one/many versions of product and summarized portfolio financial plan data, including effort (FTEs/Days/Hours) or financial data (Cost/Revenue). Includes a burn down chart for the whole portfolio and for each initiative. Report can be configured to run against each level in the strategy structure.

PRD32.png

 

Business Outcomes Supporting Capabilities
  • Tracking of product revenue or cost forecasts to ensure that they are in line with budget.
  • Enable comparisons between planning cycle baselines/snapshots to track variances in product development cost and revenue profiles, driving improvements in forecast accuracy.
  • Identify products that are forecast to perform badly as they move through the development stages so that they can be considered for a Go/Kill decision at portfolio review gates.
  • 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  Default cannot be changed
Working Version Version to consider (This version will appear first) Default is the version specified in the version_id parameter (or version marked as forecast otherwise) Version_id=
Compare to version(s) Comparison version(s) to consider Choose from list of financial versions
Default is version marked as baseline 
Default cannot be changed  
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
fm_measure=amount  
Financial Category Specify whether costs or  benefits/revenues should be displayed Values are:
  • Cost (cost)
  • Benefit/Revenue (benefit)
Financial_category=cost  
Account Types Specify the account types that should be considered This is multi select parameter Values are:
  • Capital
  • Expense
  • Labor
  • Benefit
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  Default cannot be changed
Period/Ending Starting 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 Detail Metric 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)

 

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 It is recommended that PBS parent levels are used in the first two columns.
It is recommended that the two columns are used for key status and/or responsibility attributes
pbs_level_2_prod pbs_level_3_prod pbs2_prod pbs95_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 Revenue/Cost Forecast Performance
Max Line Attributes Number of line attributes to consider in the table   Max_line_attributes=2
Include Zero Financials

☑ Added in RPM Analytics v2.2.0.
Parameter that determines whether or not to include entities with zero financials in the returned results If the entry is "N" (the default) any entities that don't have financials for the given set of parameters will not appear in the report at all

Options are No(N) or Yes(Y)
include_zero_financials=N
Detail Chart Threshold

☑ Added in RPM Analytics v2.2.0.
This entry determines whether or not the detail charts will appear. Because of the processing load that charts/graphics consume, larger portfolios could cause the report to slow down or even time out This default value of 50 should ensure that the report will run, but if there are over 50 entities the detail charts will not appear at all. If you don't want the detail charts at all you can set this value to zero (0), otherwise change the threshold value to preference detail_chart_threshold=50

 

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.
  • ​ 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.
    • Working Version; a single active financial plan version can be selected as the “main” version. This defaults to the Version Marked as Forecast.
    • Compare to Version(s); this allows the selection of one or many alternative versions that will be compared to the main (working) version. The parameter defaults to the Version Marked as Baseline.
    • 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_PROD/Product_RPM/RPM_PRD32/RPM-PRD32_v2.rdl
Database This report uses the transactional database and updates will be real-time.
Report Developer Info: RPM-PRD32_v2 RDL is a derivative of the FM32 RDL