Hierarchy financial rollup detail showing only future data for Cost Plans

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are comparing the data on the Investment, Hierarchy, Financial Rollup - Detail view to see Time Scale Value (TSV) data for Planned Costs across all the investments in the hierarchy. The Time Slice dates and 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.

Environment

Release: All Supported Releases
Component: Clarity Financial Management

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.

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.

1. Go to the Portfolio, Financials tab (this tab is available when you install the add-ins from PMO Accelerator)
2. 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:

1. The Investment, Hierarchy Financial Rollup page is accessible to end-users through a security access right.
2. Search for *Hierarchy - Financial Rollup* and remove these rights for the different investment types.

Additional Information

See also:

• Hierarchy Financial Rollup detail planned cost and benefit only display values up to 12 months in future
• Project hierarchy showing 0 for Planned Cost values