Project: Hierarchy: Financial Rollup does not rollup all costs - Detail View

Document ID : KB000022092
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

Steps to Reproduce:

  1. Create a project, for instance XYZ Online, starting on Apr/01/2011 and finishing on Jun/30/2011
  2. Associate this project to a financial entity (department and location)
  3. Create a Cost Plan starting in Apr/2011 and finishing in Jun/2011
  4. Manually enter some costs, for instance, add values as expense for Apr, May and Jun (see screenshot)
  5. Run Update Hierarchy Data job
  6. Navigate back to project XYZ and verify project hierarchy tab - Select View: Detail (see screenshot)

    Project XYX Parent - Cost Plan

    Figure 1

    Total Cost = 140,000.00

    Project XYX Parent - Hierarchy Tab without children

    Figure 2

  7. Create another project, for instance XYZ-Child, starting on Apr/01/2011 and finishing on May/31/2011
  8. Associate this project to a financial entity
  9. Create a Cost Plan starting in Apr/2011 and finishing in May/2011
  10. Manually enter some costs, for instance, add values as expense for Apr and May (see screenshot)
  11. Run Update Hierarchy Data job
  12. Navigate back to project XYZ-Child and verify project hierarchy tab - Select View: Detail (see screenshot)

    Project XYX Child - Cost Plan

    Figure 3

    Total Cost = 9,000.00

    Project XYX Child - Hierarchy Tab without children

    Figure 4

  13. Create a third project, for instance XYZ-Grand Child, starting on Feb/01/2011 and finishing on Nov/30/2011
  14. Associate this project to a financial entity
  15. Create a Cost Plan starting in Feb/2011 and finishing in Nov/2011
  16. Manually enter some costs, for instance, add values as expense for Feb through Nov (see screenshot)
  17. Run Update Hierarchy Data job
  18. Navigate back to project XYZ-Grand Child and verify project hierarchy tab - Select View: Detail (see screenshot)

    Project XYX Grand Child - Cost Plan

    Figure 5

    Figure 6

    Total Cost= 6,500.00

    Project XYX Grand Child
    - Hierarchy Tab

    Basic View - shows Planned Cost as 6,500.00 = 200 + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1000 + 1100 (Cost Plan)

    Figure 7

    Detail View does not show values for Feb/11 and Mar/11 (probably because of the time slice)


    Figure 8

  19. Navigate back to project XYZ Child, select the Hierarchy tab and add XYZ-Grand Child as a child project
  20. Run Purge Temporary Hierarchy Data job with Clear all temporary data option followed by Update Hierarchy Data job
  21. Give it some time...
  22. In the Hierarchy tab select View: Detail (see screenshot) - it rolls up all costs correctly

    Project XYX Child - Hierarchy - Detail View after adding XYZ Grand Child to XYZ Child project

    Figure 9

    It rolls up costs from April thru November but the Basic View shows totals from February thru November (6,500.00)

    Figure 10

  23. Navigate back to project XYZ-Online (XYZ-Parent), select the Hierarchy tab and add XYZ-Child as a child project
  24. Run Purge Temporary Hierarchy Data job with Clear all temporary data option followed by Update Hierarchy Data job
  25. Give it some time...
  26. Navigate back to project XYZ-Online, select the Hierarchy tab, select View: Detail (see screenshot)

    Project XYZ - Parent - Hierarchy - Basic View after adding XYZ Child to XYZ Parent project

    Figure 11

    Project XYZ - Parent - Hierarchy - Detail View after adding XYZ Child to XYZ Parent project

    Figure 12

    It does not roll up costs from Jun/2011 through Nov/11

    Same view after configuring TSV field:

    Figure 13

    44,400 + 45,500 + 60,000 = 149,900 ; this is different from 155,500.00 (Basic View)

    Note: Before April everything is zero

    Figure 14

Expected Result: All costs are rolled up and totals in the Hierarchy - Basic View match to the Hierarchy - Detail View
Actual Result: Some costs are not rolled up and totals do not match to the Hierarchy Basic View

Cause:

Caused by CLRT-60889 

Resolution:

Resolved in CA Clarity PPM 13.1.0

Workaround:
None.