;

Skip to main content

 

  • arrow icon
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

SER32 - Service Portfolio Cost Forecast Comparison

  1. Last updated
  2. Save as PDF
RPM Analytics Catalog  ▲ RPM Service Analytics  ▲ RPM Analytic SER32  ▼

 

Overview
Service portfolio report that allows the comparison of one/many versions of service and summarized portfolio financial plan data, including effort (FTEs/Days/Hours) or financial cost and recharge data. Includes a burn down chart for the whole portfolio and for each service. 

AST01.png
 

Business Outcomes Supporting Capabilities
  • Tracking of service recharge or cost forecasts to ensure that they are in line with budget.
  • Enable comparisons between planning cycle baselines/snapshots to track variances in service delivery costs.
  • Identifyservices that are forecast to perform badly.
  • Service Topology
  • Service 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)
Max Line Attributes Number of line attributes to consider in the table   Max_line_attributes=2

 

Hidden Parameter Configuration (Information for Planview Administrators)
Parameters Description Configuration Options Default/Example Settings
Table Columns 2 columns before and 2 columns after the project name can be defined It is recommended that service 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		 srv_level_2_service
srv2_service
asst701_service
serv_techval
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=Service Forecast Performance

 

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/Service_RPM/RPM_SER32/RPM-SER32_v2.rdl
Database This report uses the transactional database and updates will be real-time.
Report Developer Info: RPM-SER32_v2 RDL is a derivative of the FM32 RDL