Financial Capitalization by Investment

The Financial Capitalization by Investment report displays capital and operating amounts for each investment. These amounts include: budget or planned, actual, remaining cost, and percent spent. The report offers the ability to group by up to three options, which can be any combination of the following: Investment Manager, Business Owner, Investment Type, Project Type, and OBS Level.
ccppmop156
The Financial Capitalization by Investment report displays capital and operating amounts for each investment. These amounts include: budget or planned, actual, remaining cost, and percent spent. The report offers the ability to group by up to three options, which can be any combination of the following: Investment Manager, Business Owner, Investment Type, Project Type, and OBS Level.
The following image shows the Financial Capitalization by Investment report displaying capital and operating amounts for each investment.
Image displaying the Financial Capitalization by Investment report displaying capital and operating amounts for each investment.
This report allows you to drill down to the Financial Capitalization Detail report, by clicking an investment name, to view amounts by fiscal month.
The following image shows the Financial Capitalization Detail report that is grouped by business owner.
Image displaying the Financial Capitalization Detail report that is grouped by business owner.
The following report example is grouped by two, of the possible three, grouping options. It is grouped first by OBS Level and second by Business Owner. The grouping options are fairly flexible, allowing you to summarize the data and subtotal it by various grouping attributes including: Investment Manager, Business Owner, Investment Type, Project Type, and OBS Level. These grouping options can be applied in any order so, for example, you can group first by OBS Level, second by Investment Type, and third by Investment Manager. Alternatively, you can group first by Investment Type, second by Investment Manager, and third by OBS Level. You can also group by one attribute or three attributes, offering a wide range of grouping and subtotaling options.
The following image shows the Financial Capitalization report that is grouped by OBS and business owner.
Image displaying the Financial Capitalization report that is grouped by OBS and business owner.
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The
    Load Data Warehouse
    and
    Load Data Warehouse Access Rights
    jobs must be run before you run this report. If the Data Warehouse is not populated, the report displays a message that there are no matching records. Also, most of the report parameters do not display options.
  • The investment must have at least one financial plan for the investment to display in the report. The report has a financial plan type parameter with the values of budget or planned so you can run the report for budget or cost plan amounts. If the financial plan type parameter is budget, then the investment must have at least one approved budget for the investment to display in the report. If the financial plan type parameter is planned, then the investment must have at least one cost plan for the investment to display in the report.
  • The financial plan must have cost type selected as a grouping attribute and financial plan detail rows must exist for the capital and operating cost types. This report only includes financial plans that have cost type as a grouping attribute so if the financial plan does not group by cost type, then it does not display in the report.
  • The investment must have a department OBS unit that is associated to it to create a cost plan on the investment. For a department OBS to be available to associate to an investment, first set up a department OBS and a location OBS Administration/Organization and Access-OBS) and associate them to the investment objects (for example, Application, Project, and so on) on which you can create financial plans. Next, create an entity (Administration/Finance-Setup/Entities) and associate the department OBS and location OBS to the entity. On the entity, create fiscal time periods (Administration/Finance-Setup/Entities-Fiscal Time Periods Tab) for the period types (monthly, 13 periods, quarterly, annually) that you want to reference in creating financial plans. If you do not intend to plan by annual fiscal periods, still create them because the report requires them as explained in the next bullet item.
  • There must be fiscal time periods, with a period type of annually, created (Administration/Finance-Setup/Entities-Fiscal Time Periods Tab) that cover the periods for which you have investment financial plans in
    Clarity PPM
    . For example, if you have investments with monthly or quarterly budgets or cost plans for 2015 and 2015, then you must have annual fiscal periods that are created for 2015 and 2015 even though you are not creating budgets or cost plans by these annual periods. The report uses these annual periods to convert the budget and cost plan amounts entered so they can be reported by fiscal year, independent of how they are entered in the financial plans.
  • There must be fiscal time periods, with a period type of monthly or 13 periods, created (Administration/Finance-Setup/Entities-Fiscal Time Periods Tab). The Financial Capitalization Detail report displays amounts by fiscal period type of monthly or 13 periods, whichever you have set up in your system. If your financial plans are entered by period types of monthly or 13 periods, then the amounts display in those periods in the report as they do in the financial plan. If your financial plans are entered by period types of quarterly or annually, then the amounts display in the first month of the quarter or first month of the year, respectively. The quarter and annual amounts entered in the financial plan are not spread evenly across months in the report; they are included in the first month corresponding to the quarter or year in which the amounts are entered.
Report Properties
The following values list the report properties:
Name
: Financial Capitalization by Investment
Resource ID
: CSK_FIN_CapitalizationByInv
Description
: Financial Management (PMO Accelerator)
Folder
: CA PPM/Reports/Financial Management/Financial Capitalization by Investment
Path
: /ca_ppm/reports/financial_management/CSK_FIN_CapitalizationByInv
Data Source
: CA PPM Data Warehouse Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Investment OBS Type
investmentOBSTypeKey_1
Single-select
Query
Investment OBS Type
investmentOBSTypeKey_1
No
Investment OBS Unit
investmentOBSUnitKey_1
Single-select
Query
Investment OBS Unit
investmentOBSUnitKey_1
No
Investment Type
investmentTypeKey_1
Multiple-select
Query
Investment Type
investmentTypeKey_1
Yes
All
Investment Manager
investmentManagerKey_1
Multiple-select
Query
Investment Manager
investmentManagerKey_1
No
Investment
investmentKey_1
Multiple-select
Query
Investment
investmentKey_1
No
Investment Status
investmentStatusKey_1
Multiple-select
Query
Investment Status
investmentStatusKey_1
No
Financial Plan Type
financialPlanTypeKey_1
Single-select
List of Values
Financial Plan Type
financialPlanTypeKey_1
Yes
Planned
Fiscal Year
fiscalYearKey_1
Multiple-select
Query
Fiscal Year
fiscalYearKey_1
Yes
Report Currency
currencyKey_1
Single-select
Query
Report Currency
currencyKey_1
No
% Spent Threshold
pctSpentThreshold
Single Value
Number
% Spent Threshold
pctSpentThreshold
Yes
10
Group By 1
groupInvManagerBusOwnerOBS1
Single-select
List of Values
Group By 1
groupInvManagerBusOwnerOBS1
Yes
No Grouping
Group By 2
groupInvManagerBusOwnerOBS2
Single-select
List of Values
Group By 2
groupInvManagerBusOwnerOBS2
Yes
No Grouping
Group By 3
groupInvManagerBusOwnerOBS3
Single-select
List of Values
Group By 3
groupInvManagerBusOwnerOBS3
Yes
No Grouping
Include Inactive Investments?
includeInactiveInvestments
Boolean
Include Inactive Investments?
includeInactiveInvestments
No
Unchecked
Database Schema
dwhDBSchema
Hidden
Not Applicable
Yes
Passed through
Clarity PPM
UI Theme
ppmUserUITheme
Hidden
Not Applicable
Yes
Passed through
Clarity PPM
Language
ppmUserLanguage
Hidden
Not Applicable
Yes
Passed through
Clarity PPM
User ID
ppmUser
Hidden
Not Applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
The following values list the lookup values:
Investment Type
: All, Application, Asset, Idea, Other Work, Product, Project, Service
Financial Plan Type
: Budget, Planned
Group By 1, 2 and 3
: No Grouping, Investment Manager, Business Owner, Investment Type, Project Type, OBS Level 1-10
Parameter Explanations
The following list describes the parameters:
  • The Investment OBS Type is a cascading parameter and determines which units are listed in the Investment OBS Unit parameter. This parameter is not used to control which investments display in the report.
  • The Investment OBS Unit parameter displays values that are based upon the Investment OBS Type selected. When you select an OBS unit in this parameter, the report displays the investments that are attached to the OBS unit and descendants of the unit you select.
  • The Financial Plan Type parameter allows you to select which type of financial plan to include in the report. You can run the report to display budget amounts from the budget or planned amounts from the cost plan. This option is available because sometimes cost plans are implemented without budgets so this parameter gives you the flexibility to select which plan type to show in the report.
    The Financial Plan Type parameter works as follows:
    • Budget
      . The budget amounts in the report are based on the current approved budget. The preceding  screen captures were run with the option of planned. If they were run with the option of budget, then they would display the word budget where they display the word planned in the main report column headings and subreport row labels
    • Planned
      . The planned amounts in the report are based on the current cost plan of record. The preceding screen captures display the amounts as planned because this is the parameter value that is selected when running the report.
  • The Fiscal Year parameter allows you to control which costs, from the financial plans and actual transactions, are included in the report. When you select a fiscal year, the budget or planned amounts are restricted to only display the amounts within the fiscal year you select. The same applies to actual amounts. You can view costs for one or several fiscal years, regardless of whether the financial plans are entered by period types of monthly, 13 periods, quarterly, or annually.
  • The Report Currency parameter allows you to convert the amounts in the report to one currency for reporting purposes. If you select a currency in the parameter, then the amounts in the report is converted into that currency per the exchange rates set up in the product, if the report currency is different from the investment currency. If you do not select a currency in the parameter, then the report displays amounts in the entity  home currency of the department that is associated to the investment.
    To use this Report Currency parameter to convert currencies, you must have multi-currency enabled in your installation of the product (Administration/Finance-Setup/Default
    s
    ). In the Currency section, there is a System field that must be set to Multi Currency. In addition to enabling multi-currency, also activate the currencies you want to use in the product (Administration/Finance-Setup/Currency). Lastly, set up foreign exchange rates in the product (Administration/Finance-Setup/Foreign Exchange Rates). The report uses exchange rates with an exchange rate type of 'Average' so set up exchange rates of this type.
  • The % Spent Threshold parameter allows you to control when the background color changes from yellow to red for the % spent columns in the report. If the % spent in the report is less or equal to 100%, then the background color is green. If the % spent is greater than 100%, then it is yellow until it reaches the % spent threshold that is entered as a parameter. Amounts that are greater than the threshold are red. In the preceding screen captures, the % spent threshold parameter that is entered when running the report is 10%. Entering a value of 10% means that the % spent turns red when it is greater than 110%. Enter 10% as the threshold, not 110%.
  • The report has Group By 1, 2, and 3 parameters that allow you to control how the report is grouped. You can group the report by up to three options, which can be any combination of the following grouping options:
    • No Grouping
      This option does not group the report so you can select this value if you do not want to do a grouping for one of the group by options
    • Investment Manager
      This option groups the report by investment manager.
    • Business Owner
      This option groups the report by business owner.
    • Investment Type
      This option groups the report by investment type. The values for investment type are: Application, Asset, Idea, Other Work, Product, Project, and Service
    • Project Type
      This option groups the report by project type. The values for project type are: Major Project, Application Change, and Infrastructure Deployment. The project type is a configurable lookup so values can be added, modified, or deactivated.
    • OBS Level 1-10
      This option groups the report by OBS level and requires that you select a unit in the investment OBS parameter to group by an OBS level. The investment OBS parameter and grouping by an OBS level work with one another. The investment OBS parameter determines which OBS you group by when you select a group by level. You can group by any OBS level from 1 to 10, which is the maximum number of levels for an OBS supported in the product. OBS level 1 is the top level in the hierarchy and OBS level 10 is bottom level in the hierarchy. When you group by an OBS level, the investments that are attached to OBS units at the level you select and any units below the level you select are rolled up to the group by level of the report.
      If you group by an OBS level that is lower in the hierarchy, then the report groups the investments by this level (for example, OBS Level 4). If investments are associated to units higher than level 4 (for example, investments are attached to levels 2 and 3), then the investments that are associated to units higher in the hierarchy display in the report in an Undefined grouping. The Undefined grouping indicates that there is no OBS unit that is defined for the investment at the level by which you are grouping.
      If you group by an OBS level but you do not select a unit in the investment OBS parameter, then the report returns results. However, it will not group by an OBS level because it relies on the investment OBS parameter to determine which OBS to use for grouping.
  • The investment statuses are displayed based on the existing investment statuses in the environment such as test, dev, or prod. For example, if there are investments with only Approved status, then only the Approved investment status displays.
Report Fields and Calculations
The report displays the investment name, investment start date, and investment finish date. If the financial plan type parameter is set to budget, then the report displays the following columns: budget, capital budget, capital actual, capital budget remaining, capital % spent, operating budget, operating actual, operating budget remaining, and operating % spent. For budgets, the report only includes the current approved budget amounts.
If the financial plan type parameter is set to planned, then the report displays the following columns: planned, capital planned, capital actual, capital planned remaining, capital % spent, operating planned, operating actual, operating planned remaining, and operating % spent. For planned, the report only includes the current plan of record cost plan amounts.
The report requires cost types with IDs of 'CAPITAL' and 'OPERATING'. Financial plans must be grouped by cost type for amounts to display in this report. The current approved budget or cost plan of record is the only financial plan included. The plan of record for the cost plan is the one designated as plan of record. The plan of record for the budget is current approved budget. Budget and cost plans are included; benefit plans are excluded.
If the report currency parameter is not selected, then the report will display all investments in their home currency. This is the entity  home currency of the department that is associated to the investment. In this case, an extra currency column displays in the report to the right of the investment name to give visibility into the currency of the investment because the investments can be in different currencies. If the report currency parameter is set to a currency, then all the investments in the report are  converted from their home currency to the report currency, if the two are different, so you can view all investments in the same currency. In this case, the currency is displayed in parentheses in the report title instead of as a column in the report because all the investments are in the same report currency. In order to use the report currency parameter for converting amounts, your 
Clarity PPM
installation must have multi-currency enabled. Currency conversions are calculated based on the foreign exchange rates set up with a type of average. They are also based on the current date so the exchange rate effective date must be the same or earlier than the current date. With these conditions met, the exchange rate effective date closest to the current date is the exchange rate that is used for the conversions.
Actual financial transaction cost amounts only include transactions that are processed and posted. Any other status is a transaction that is adjusted, reversed or updated and those transactions are excluded. Actual financial transaction cost amounts are in the currency that is the entity  home currency of the department that is associated to the investment. The report displays amounts that are based on the fiscal year parameter selected.
This report contains the following calculations, which are all subject to the fiscal year parameter:
  • Budget or Planned
    This is the approved budget or planned cost for the cost plan of record.
  • Capital Budget or Planned
    Budget or Planned Cost where the Cost Type ID is 'CAPITAL'
  • Capital Actual
    Actual Cost where the Cost Type ID is 'CAPITAL'
  • Capital Budget or Planned Remaining
    Capital Budget or Planned – Capital Actual
  • Capital % Spent
    (Capital Actual / Capital Budget or Planned) x 100
    Capital % Spent background color is determined as follows:
    • Green. The % Spent is less than or equal to 100%.
    • Yellow. The % Spent is greater than 100% and it exceeds 100% by a value that is less than or equal to the % Spent threshold entered as a parameter.
    • Red. The % Spent is greater than 100% and it exceeds 100% by a value that is greater than the % Spent threshold entered as a parameter.
  • Operating Budget or Planned.
    Budget or Planned Cost where the Cost Type ID is 'OPERATING'
  • Operating Actual
    . Actual Cost where the Cost Type ID is 'OPERATING'
  • Operating Budget or Planned Remaining
    . Operating Budget or Planned – Operating Actual
  • Operating % Spent
    (Operating Actual / Operating Budget or Planned) x 100
    Operating % Spent background color is determined as follows:
    • Green. The % Spent is less than or equal to 100%.
    • Yellow. The % Spent is greater than 100% and it exceeds 100% by a value that is less than or equal to the % Spent threshold entered as a parameter.
    • Red. The % Spent is greater than 100% and it exceeds 100% by a value that is greater than the % Spent threshold entered as a parameter.
Report Security
Security is determined by investment view rights.