Skip to main content
Planview PortfoliosGlossary Language Selector
  1. Deutsch
  2. English
  3. Español
  4. Français
  5. Italiano

  6. Other Languages

    (machine translation)

Planview Customer Success Center

STR31 - Strategic Portfolio Cost and Benefit Analysis

  1. Last updated
  2. Save as PDF

Overview

Strategic 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.

 

clipboard_e0d130f42d6d4aa63adee12bb5423cb82.png

STR31 Strategic Portfolio Cost and Benefit Analysis example

           

Business Outcomes

  • 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 spent, or incremental revenue
  • Ensure that spend and revenue/benefits are smoothed out across the planning time horizon.

           

           

Supporting Capabilities

  • Budgeting
  • Strategic Planning

           

           

Administration: User Parameter Configuration

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
 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
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 strategy (program) attributes (including strategy structure parent levels)
  • The levels of the account structure
  • Any of the line attribute
 Slicer=str33_strategy
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_attribs=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. Available Options are:
  • Grouped/Collapsed
  • Plain/Excel
Default value is controlled through the table_layout parameter;
  • table_layout=grouped
  • table_layout=plain
 table_layout=grouped

           

           

Administration: Hidden Parameter Configuration

Parameters Description Configuration Options Default/Example Settings
Table Columns 2 columns before and 2 columns after the strategy 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)+ sbs_level_2_strategy
sbs_level_3_strategy
spsstatus_strategy
sps2_strategy
Depth Restriction This parameter is used to set the level of the structure that the report is executed on, restricting the results to a specified depth of the Strategic Breakdown Structure. Use the parameter:
  •  restrict_depth=
to specify the depth

A value of zero (0) removes such limit.		 restrict_depth=0
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=Strategic Portfolio Cost and Benefit Analysis
Entity Header

 		 Parameter used to control how the column header for the primary entity is determined.

 		 Add a new entry under the Parameter Default section using the following syntax:
  • entity_header=
If not configured it will use the name of the level of the primary structure.		 No entry exists as default

           

           

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 thProviding 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 Planview Portfolios shows data from the financial plan. The following parameters are used to determine what is shown;
    • Currency: if 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_PROD/Strategy_RPM/RPM-STR31/RPM-STR31_v2.rdl
Database This report uses the transactional database and updates will be real-time.
Report Developer Info RPM-STR31_v2 RDL is a derivative of the FM31 RDL