Project Hierarchy Financial Rollup Detail Time Slice Dates and Data showing only future data for Cost Plans

Article Id: 19069
Status: Published
Updated On: 10-07-2020 11:32
Legacy Id: TEC606258
Products:
STARTER PACK-CLARITY PPM , Clarity PPM On Premise , Clarity PPM SaaS
Issue/Introduction:

  • We are comparing the data on the Investment, Hierarchy, Financial Rollup - Detail view to see TSV data for Planned Costs across all the investments in the hierarchy.
  • The data for the Planned Costs seem to only show the current month plus eleven months into the future (total 12 months).
  • Can we change this configuration to show past planned amounts?
Steps to Reproduce:
  1. Configure Financials with Fiscal Time periods going back at least a few months or more
  2. Create some cost plans
  3. Execute jobs for Time slicing, Investment Allocation and Datamart Extraction
  4. View the Project, Hierarchy, Financial Rollup : Detail view (time-scale varying)
Expected Result: To see cost plan TSV data in the past
Actual Result: We only see cost plan TSV data beginning with the current month.

Cause:

This is working by design:

  • The Investment Hierarchy Financial Rollup Detail View uses internal insta-slices that cannot be modified and is to designed to only show the current month and into the future for a total of 12 months.
  • If you change the TSV display to group by Quarterly, or Annually:
    • The amounts in the 'Monthly' internal slices will be used and still will have less than the amounts that would appear on the Cost Plan if there is planned data prior to the current month.

Environment:

Release: All Supported Releases
Component: Clarity Financial Management

Resolution:

  • If this page causes confusion for your end-users, it is our recommendation to use the new Portfolio Functionality, by adding the group of investments into a Portfolio.
    • Go to the Portfolio, Financials tab (this tab is available when you install the add-ins from PMO Accelerator)
    • View the TSV data on this page and it will show past TSV period data.
    • Using this will also allow the end-user to utilize the new portfolio functionality for greater analysis of the data and planning.
  • You can also then remove the rollup view using the below:
    • The Investment, Hierarchy Financial Rollup page is accessible to end-users through a security access right.
    • Search for *Hierarchy - Financial Rollup* and remove these rights for the different investment types.

Additional Information:

KB 22562 - Project Hierarchy Financial Rollup Detail View Planned Cost and Planned Benefit amounts only display values up to 12 months in future

KB 4366 - Project hierarchy Showing 0 on Planned Cost Values