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

WRK31 - Work Portfolio Financial Analysis

  1. Last updated
  2. Save as PDF

Overview

Work portfolio report that allows the analysis of project and 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 work alternate structure or a line attribute of the selected accounts. 

           

clipboard_ea8e0ad7eadefee285ddfd7012591d201.png

WRK31 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

  • Financial Management
  • Project Monitoring and Status

           

           

User Parameter Configuration (for 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
 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.

An Account Type Column will appear in the table.		 There is a line for each possible value: account_type=ACTP$EXP account_type=ACTP$CAP account_type=ACTP$LAB account_type=ACTP$BEN
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
An account structure slicing default can be achieved using the following: 
slicer=FMA|2 (for level 2)
slicer=FMA|3 (for level 3)		 Slicer=BLA|cbs1

Note: BLA indicates that it is a 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
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:
Grouped/Collapsed
Plain/Excel
Default value is controlled through the table_layout parameter;
table_layout=grouped
table_layout=plain		 table_layout=grouped

           

           

Hidden Parameter Configuration (for Administrators)

Parameters Description Configuration Options Default/Example Settings
Table Columns 2 columns before and 10 columns after the project name can be defined. Four are required. 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)+

The detail table layout parameter must be in the plain format (table_layout=plain) in order to display columns 5-12.		 Wbs_level_2_Plan
Wbs_level_3_Plan
Wbs20_Plan
Wbs22_plan
Max Line Attributes Number of line attributes to display in the detail data table.   max_line_attribs=2
Report Title Configurable report title that appears at the top of the report. If a longer report title is required, create additional report_title=xxx entries. These will be concatenated together based on the order in which they are listed in the configuration structure. report_title=Work Portfolio Financial 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
Financial Model This parameter provides the ability to override the global setting for the financial model for this report. The financial model for this report can be changed from the parameter defaults by using the following syntax:
  • model_id=

Model IDs are listed in the ADM01 report

 No override exists as default

Financial Model will not differ from Global Default unless entry is added

           

           

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 Portfolios is configured to support multi-currency, 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/FastTrack/Mixed_Use/FM31-PortfolioFinancialAnalysis/FM31.rdl
Database This report uses the transactional database and updates will be real-time.
This report can be used in both a work portfolio and a single project (work-project) dashboard.